eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PSP_ELEMENT_GROUP_V

Source

View Text - Preformatted


SELECT GE.ELEMENT_GROUP_ID , GE.ELEMENT_TYPE_ID , HR.ELEMENT_NAME , EG.ELEMENT_GROUP_NAME , EG.BUSINESS_GROUP_ID , EG.SET_OF_BOOKS_ID FROM PSP_GROUP_ELEMENT_LIST GE, PSP_ELEMENT_GROUPS EG, PAY_ELEMENT_TYPES_F HR, PSP_ELEMENT_TYPES ET WHERE EG.ELEMENT_GROUP_ID = GE.ELEMENT_GROUP_ID AND EG.BUSINESS_GROUP_ID = ET.BUSINESS_GROUP_ID AND EG.SET_OF_BOOKS_ID = ET.SET_OF_BOOKS_ID AND ET.ELEMENT_TYPE_ID = GE.ELEMENT_TYPE_ID AND ET.ELEMENT_TYPE_ID = HR.ELEMENT_TYPE_ID GROUP BY GE.ELEMENT_GROUP_ID, GE.ELEMENT_TYPE_ID, HR.ELEMENT_NAME, EG.ELEMENT_GROUP_NAME, EG.BUSINESS_GROUP_ID, EG.SET_OF_BOOKS_ID UNION ALL SELECT TO_NUMBER(NULL), ET.ELEMENT_TYPE_ID, ET.ELEMENT_NAME, ET.ATTRIBUTE_CATEGORY, ET.BUSINESS_GROUP_ID, ET.SET_OF_BOOKS_ID FROM PSP_ELEMENT_TYPES_V ET WHERE NOT EXISTS (SELECT 1 FROM psp_element_groups peg, psp_group_element_list pgel WHERE peg.element_group_id = pgel.element_group_id AND peg.business_group_id = et.business_group_id AND peg.set_of_books_id = et.set_of_books_id AND pgel.element_type_id = et.element_type_id)

View Text - HTML Formatted

SELECT GE.ELEMENT_GROUP_ID
, GE.ELEMENT_TYPE_ID
, HR.ELEMENT_NAME
, EG.ELEMENT_GROUP_NAME
, EG.BUSINESS_GROUP_ID
, EG.SET_OF_BOOKS_ID
FROM PSP_GROUP_ELEMENT_LIST GE
, PSP_ELEMENT_GROUPS EG
, PAY_ELEMENT_TYPES_F HR
, PSP_ELEMENT_TYPES ET
WHERE EG.ELEMENT_GROUP_ID = GE.ELEMENT_GROUP_ID
AND EG.BUSINESS_GROUP_ID = ET.BUSINESS_GROUP_ID
AND EG.SET_OF_BOOKS_ID = ET.SET_OF_BOOKS_ID
AND ET.ELEMENT_TYPE_ID = GE.ELEMENT_TYPE_ID
AND ET.ELEMENT_TYPE_ID = HR.ELEMENT_TYPE_ID GROUP BY GE.ELEMENT_GROUP_ID
, GE.ELEMENT_TYPE_ID
, HR.ELEMENT_NAME
, EG.ELEMENT_GROUP_NAME
, EG.BUSINESS_GROUP_ID
, EG.SET_OF_BOOKS_ID UNION ALL SELECT TO_NUMBER(NULL)
, ET.ELEMENT_TYPE_ID
, ET.ELEMENT_NAME
, ET.ATTRIBUTE_CATEGORY
, ET.BUSINESS_GROUP_ID
, ET.SET_OF_BOOKS_ID
FROM PSP_ELEMENT_TYPES_V ET
WHERE NOT EXISTS (SELECT 1
FROM PSP_ELEMENT_GROUPS PEG
, PSP_GROUP_ELEMENT_LIST PGEL
WHERE PEG.ELEMENT_GROUP_ID = PGEL.ELEMENT_GROUP_ID
AND PEG.BUSINESS_GROUP_ID = ET.BUSINESS_GROUP_ID
AND PEG.SET_OF_BOOKS_ID = ET.SET_OF_BOOKS_ID
AND PGEL.ELEMENT_TYPE_ID = ET.ELEMENT_TYPE_ID)