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.PAY_GB_COURT_ORDERS_V

Source

View Text - Preformatted


SELECT distinct ele.element_type_id ,ent.element_entry_id ,lnk.element_link_id ,ele.element_name ,substr(ipv1.input_value_id,1,20) TYPE_IPV_ID ,substr(eev1.screen_entry_value,1,20) TYPE ,substr(ipv2.input_value_id,1,20) REFERENCE_IPV_ID ,substr(eev2.screen_entry_value,1,20) REFERENCE ,ent.subpriority ,ent.assignment_id ,ent.effective_start_date ,ent.effective_end_date ,ent.object_version_number FROM pay_element_entry_values_f eev1 ,pay_element_entry_values_f eev2 ,pay_element_entries_f ent ,pay_element_links_f lnk ,pay_input_values_f ipv1 ,pay_input_values_f ipv2 ,pay_element_types_f ele ,fnd_sessions ses WHERE ele.element_name in ('Court Order','Court Order NTPP', 'EAS Scotland','EAS Scotland NTPP') and ses.session_id = userenv('SESSIONID') and ses.effective_date between ent.effective_start_date and ent.effective_end_date and lnk.element_type_id = ele.element_type_id and ent.element_link_id = lnk.element_link_id and ent.element_entry_id = eev1.element_entry_id and ent.element_entry_id = eev2.element_entry_id and eev1.input_value_id = ipv1.input_value_id and ipv1.element_type_id = ele.element_type_id and ipv1.name ='Type' and eev2.input_value_id = ipv2.input_value_id and ipv2.element_type_id = ele.element_type_id and ipv2.name ='Reference' and ses.effective_date between eev1.effective_start_date and eev1.effective_end_date and ses.effective_date between eev2.effective_start_date and eev2.effective_end_date and ses.effective_date between ipv1.effective_start_date and ipv1.effective_end_date and ses.effective_date between ipv2.effective_start_date and ipv2.effective_end_date and ses.effective_date between lnk.effective_start_date and lnk.effective_end_date and ses.effective_date between ele.effective_start_date and ele.effective_end_date UNION SELECT distinct ele.element_type_id ,ent.element_entry_id ,lnk.element_link_id ,ele.element_name ,null ,null ,substr(ipv2.input_value_id,1,20) REFERENCE_IPV_ID ,substr(eev2.screen_entry_value,1,20) REFERENCE ,ent.subpriority ,ent.assignment_id ,ent.effective_start_date ,ent.effective_end_date ,ent.object_version_number FROM pay_element_entry_values_f eev2 ,pay_element_entries_f ent ,pay_element_links_f lnk ,pay_input_values_f ipv2 ,pay_element_types_f ele ,fnd_sessions ses WHERE ele.element_name in ('CAO Scotland','CAO Scotland NTPP', 'CMA Scotland','CMA Scotland NTPP') and ses.session_id = userenv('SESSIONID') and ses.effective_date between ent.effective_start_date and ent.effective_end_date and lnk.element_type_id = ele.element_type_id and ent.element_link_id = lnk.element_link_id and ent.element_entry_id = eev2.element_entry_id and eev2.input_value_id = ipv2.input_value_id and ipv2.element_type_id = ele.element_type_id and ipv2.name ='Reference' and ses.effective_date between eev2.effective_start_date and eev2.effective_end_date and ses.effective_date between ipv2.effective_start_date and ipv2.effective_end_date and ses.effective_date between lnk.effective_start_date and lnk.effective_end_date and ses.effective_date between ele.effective_start_date and ele.effective_end_date

View Text - HTML Formatted

SELECT DISTINCT ELE.ELEMENT_TYPE_ID
, ENT.ELEMENT_ENTRY_ID
, LNK.ELEMENT_LINK_ID
, ELE.ELEMENT_NAME
, SUBSTR(IPV1.INPUT_VALUE_ID
, 1
, 20) TYPE_IPV_ID
, SUBSTR(EEV1.SCREEN_ENTRY_VALUE
, 1
, 20) TYPE
, SUBSTR(IPV2.INPUT_VALUE_ID
, 1
, 20) REFERENCE_IPV_ID
, SUBSTR(EEV2.SCREEN_ENTRY_VALUE
, 1
, 20) REFERENCE
, ENT.SUBPRIORITY
, ENT.ASSIGNMENT_ID
, ENT.EFFECTIVE_START_DATE
, ENT.EFFECTIVE_END_DATE
, ENT.OBJECT_VERSION_NUMBER
FROM PAY_ELEMENT_ENTRY_VALUES_F EEV1
, PAY_ELEMENT_ENTRY_VALUES_F EEV2
, PAY_ELEMENT_ENTRIES_F ENT
, PAY_ELEMENT_LINKS_F LNK
, PAY_INPUT_VALUES_F IPV1
, PAY_INPUT_VALUES_F IPV2
, PAY_ELEMENT_TYPES_F ELE
, FND_SESSIONS SES
WHERE ELE.ELEMENT_NAME IN ('COURT ORDER'
, 'COURT ORDER NTPP'
, 'EAS SCOTLAND'
, 'EAS SCOTLAND NTPP')
AND SES.SESSION_ID = USERENV('SESSIONID')
AND SES.EFFECTIVE_DATE BETWEEN ENT.EFFECTIVE_START_DATE
AND ENT.EFFECTIVE_END_DATE
AND LNK.ELEMENT_TYPE_ID = ELE.ELEMENT_TYPE_ID
AND ENT.ELEMENT_LINK_ID = LNK.ELEMENT_LINK_ID
AND ENT.ELEMENT_ENTRY_ID = EEV1.ELEMENT_ENTRY_ID
AND ENT.ELEMENT_ENTRY_ID = EEV2.ELEMENT_ENTRY_ID
AND EEV1.INPUT_VALUE_ID = IPV1.INPUT_VALUE_ID
AND IPV1.ELEMENT_TYPE_ID = ELE.ELEMENT_TYPE_ID
AND IPV1.NAME ='TYPE'
AND EEV2.INPUT_VALUE_ID = IPV2.INPUT_VALUE_ID
AND IPV2.ELEMENT_TYPE_ID = ELE.ELEMENT_TYPE_ID
AND IPV2.NAME ='REFERENCE'
AND SES.EFFECTIVE_DATE BETWEEN EEV1.EFFECTIVE_START_DATE
AND EEV1.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN EEV2.EFFECTIVE_START_DATE
AND EEV2.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN IPV1.EFFECTIVE_START_DATE
AND IPV1.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN IPV2.EFFECTIVE_START_DATE
AND IPV2.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN LNK.EFFECTIVE_START_DATE
AND LNK.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN ELE.EFFECTIVE_START_DATE
AND ELE.EFFECTIVE_END_DATE UNION SELECT DISTINCT ELE.ELEMENT_TYPE_ID
, ENT.ELEMENT_ENTRY_ID
, LNK.ELEMENT_LINK_ID
, ELE.ELEMENT_NAME
, NULL
, NULL
, SUBSTR(IPV2.INPUT_VALUE_ID
, 1
, 20) REFERENCE_IPV_ID
, SUBSTR(EEV2.SCREEN_ENTRY_VALUE
, 1
, 20) REFERENCE
, ENT.SUBPRIORITY
, ENT.ASSIGNMENT_ID
, ENT.EFFECTIVE_START_DATE
, ENT.EFFECTIVE_END_DATE
, ENT.OBJECT_VERSION_NUMBER
FROM PAY_ELEMENT_ENTRY_VALUES_F EEV2
, PAY_ELEMENT_ENTRIES_F ENT
, PAY_ELEMENT_LINKS_F LNK
, PAY_INPUT_VALUES_F IPV2
, PAY_ELEMENT_TYPES_F ELE
, FND_SESSIONS SES
WHERE ELE.ELEMENT_NAME IN ('CAO SCOTLAND'
, 'CAO SCOTLAND NTPP'
, 'CMA SCOTLAND'
, 'CMA SCOTLAND NTPP')
AND SES.SESSION_ID = USERENV('SESSIONID')
AND SES.EFFECTIVE_DATE BETWEEN ENT.EFFECTIVE_START_DATE
AND ENT.EFFECTIVE_END_DATE
AND LNK.ELEMENT_TYPE_ID = ELE.ELEMENT_TYPE_ID
AND ENT.ELEMENT_LINK_ID = LNK.ELEMENT_LINK_ID
AND ENT.ELEMENT_ENTRY_ID = EEV2.ELEMENT_ENTRY_ID
AND EEV2.INPUT_VALUE_ID = IPV2.INPUT_VALUE_ID
AND IPV2.ELEMENT_TYPE_ID = ELE.ELEMENT_TYPE_ID
AND IPV2.NAME ='REFERENCE'
AND SES.EFFECTIVE_DATE BETWEEN EEV2.EFFECTIVE_START_DATE
AND EEV2.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN IPV2.EFFECTIVE_START_DATE
AND IPV2.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN LNK.EFFECTIVE_START_DATE
AND LNK.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN ELE.EFFECTIVE_START_DATE
AND ELE.EFFECTIVE_END_DATE