View: PAY_GB_COURT_ORDERS_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_GB_COURT_ORDERS_V

View Text

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

Columns