User login
Sponsored links
Recent blog posts
- Unwanted Save Warnings in Display Only Pages
- Breadcrumb SQL to find the Navigation path for the component in the PIA
- Application Designer Index naming convention
- How to create Trigger in DB2
- Emplid increment automatically
- How can we romove multiple duplicate rows of data printing under each Print command in SQR Program?
- How can we call Dynamic Calling section in Peoplesoft Application Engine program?
- How can we write multiple SQL Commands/Statements under one Action by using one function?
- Peoplesoft BU VS Record Groups VS Record Group Controls VS Control Table VS Table set Sharing VS Table SETID?
- Difference between Custom and Customised objects in Peoplesoft?
Is Component Attached to a Menu?
Fri, 01/25/2008 - 2:24pm — Lepa
This SQL will help you find the menus a specific component is attached to.
-- Is component attached to a menu?
-- List all the Menus that have a specific component
SELECT * FROM PSMENUITEM menu
WHERE pnlgrpname = :component_name
AND ITEMTYPE <> 8;
-- List all the Menus that have a specific component
SELECT * FROM PSMENUITEM menu
WHERE pnlgrpname = :component_name
AND ITEMTYPE <> 8;
Bookmark/Search this post with
Please try to help out with unanswered topics on the forum. Chances are you have had the same issue/question some time in your IT career!
Unanswered Forum Posts
| Title | Under | Posted on |
|---|---|---|
| nVision Tabular Report through PIA with prompts | PeopleSoft Technical | 02/02/2012 - 10:07pm |
| Can we create an AE to mass update Position - Jobcode data? | PeopleSoft Technical | 01/18/2012 - 3:11am |
| Pay Components on job data can be defaulted and setup based on the rules? | PeopleSoft Functional | 01/05/2012 - 4:58am |
| PSFT Authentication token failed for Node PSFT_HR | PeopleSoft Technical | 01/03/2012 - 12:21am |
Stay updated
CompShack is a user driven Dev2Dev IT community. Developers can ask questions, help answer questions, or just browse code and articles contributed by users. No registration required.
You can register if you want to contribute code samples, share your knowledge at your own blog, and become adored in the community!
About Lepa
Job title
Application Developer
Poll
New forum topics
- nVision Tabular Report through PIA with prompts
- Enable/Install GP and T&L modules on existing HRMS System
- How to get the list of tables having specific field as key.
- How to populate data into grid, click on pushbutton
- peoplesoft
- Can we create an AE to mass update Position - Jobcode data?
- How to do the Upgradation from one version to another version
- operatorid and grid
Recent comments
- Re: Component Permission List Query
3 days 12 hours ago - Re: How to populate data into grid, click on pushbutton
3 days 20 hours ago - Re: Arrays in PeopleSoft
5 days 13 hours ago - Re: I want to add a hyperlink to a peoplesoft delivered ...
5 days 14 hours ago - Re: How to get the list of tables having specific field as key.
5 days 14 hours ago - Re: I want to add a hyperlink to a peoplesoft delivered ...
1 week 2 days ago - Re: inserting rows within standalone rowset without fill
1 week 3 days ago - Re: How to populate data into grid, click on pushbutton
1 week 3 days ago - Re: Name change Workflow using PS role query
1 week 4 days ago - xml publisher
1 week 4 days ago
Comments
hi,
i am new to people soft
why u have given in where condition 8
it may be a silly question for u
but as a beginer its helpfull to me
so please help me...
thanks in advance
anitha
Post new comment