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_RUN_RESULTS_V

Source

View Text - Preformatted


SELECT /*+ INDEX (rrv PAY_RUN_RESULT_VALUES_PK) */ RRS.ASSIGNMENT_ACTION_ID , RRS.RUN_RESULT_ID , ETYTL.ELEMENT_NAME , HR_GENERAL.START_OF_TIME ELE_START_DATE , HR_GENERAL.END_OF_TIME ELE_END_DATE , CLATL.CLASSIFICATION_NAME , DECODE ( RRS.STATUS , 'R' , LO1.MEANING , 'O' , LO1.MEANING , 'PA', LO1.MEANING , NULL ) MODIFIED , ETY.OUTPUT_CURRENCY_CODE , RRV.RESULT_VALUE RESULT_VALUE , HR_GENERAL.START_OF_TIME INV_START_DATE , HR_GENERAL.END_OF_TIME INV_END_DATE , INV.UOM UOM , LO2.MEANING UNITS , INV.INPUT_VALUE_ID , RRS.START_DATE , RRS.END_DATE, ETY.processing_priority processing_priority FROM PAY_ELEMENT_TYPES_F ETY, PAY_ELEMENT_TYPES_F_TL ETYTL, PAY_ELEMENT_CLASSIFICATIONS CLA, PAY_ELEMENT_CLASSIFICATIONS_TL CLATL, PAY_RUN_RESULT_VALUES RRV, PAY_INPUT_VALUES_F INV, PAY_RUN_RESULTS RRS, ( select meaning, LOOKUP_CODE from HR_LOOKUPS WHERE LOOKUP_TYPE = 'RUN_RESULT_STATUS' ) LO1, ( select meaning,lookup_code from HR_LOOKUPS where LOOKUP_TYPE = 'UNITS' ) LO2, PAY_ASSIGNMENT_ACTIONS ASACT, PAY_PAYROLL_ACTIONS PACT WHERE ETY.element_type_id = ETYTL.element_type_id AND ETYTL.LANGUAGE = userenv('LANG') AND CLA.Classification_id = CLATL.classification_id AND CLATL.LANGUAGE = userenv('LANG') AND INV.ELEMENT_TYPE_ID = ETY.ELEMENT_TYPE_ID AND RRS.ELEMENT_TYPE_ID = ETY.ELEMENT_TYPE_ID AND CLA.CLASSIFICATION_ID = ETY.CLASSIFICATION_ID AND PACT.PAYROLL_ACTION_ID = ASACT.PAYROLL_ACTION_ID AND ASACT.ASSIGNMENT_ACTION_ID = RRS.ASSIGNMENT_ACTION_ID AND RRS.RUN_RESULT_ID = RRV.RUN_RESULT_ID AND RRV.INPUT_VALUE_ID = INV.INPUT_VALUE_ID AND LO1.LOOKUP_CODE = RRS.STATUS AND INV.NAME = 'Pay Value' AND LO2.LOOKUP_CODE = INV.UOM AND PACT.EFFECTIVE_DATE BETWEEN INV.EFFECTIVE_START_DATE AND INV.EFFECTIVE_END_DATE AND PACT.EFFECTIVE_DATE BETWEEN ETY.EFFECTIVE_START_DATE AND ETY.EFFECTIVE_END_DATE UNION SELECT RRS.ASSIGNMENT_ACTION_ID, RRS.RUN_RESULT_ID, ETYTL.ELEMENT_NAME, ETY.EFFECTIVE_START_DATE ELE_START_DATE, ETY.EFFECTIVE_END_DATE ELE_END_DATE, CLATL.CLASSIFICATION_NAME, DECODE ( RRS.STATUS , 'R' , LO1.MEANING , 'O' , LO1.MEANING , 'PA', LO1.MEANING , NULL ) MODIFIED , ETY.OUTPUT_CURRENCY_CODE, NULL RESULT_VALUE, FND_DATE.CANONICAL_TO_DATE('0001/01/01') INV_START_DATE, FND_DATE.CANONICAL_TO_DATE('4712/12/31') INV_END_DATE, NULL UOM, NULL UNITS, fnd_number.canonical_to_number(NULL) INPUT_VALUE_ID, RRS.START_DATE, RRS.END_DATE, ETY.processing_priority processing_priority FROM PAY_ELEMENT_TYPES_F ETY, PAY_ELEMENT_TYPES_F_TL ETYTL, PAY_ELEMENT_CLASSIFICATIONS_TL CLATL, PAY_ELEMENT_CLASSIFICATIONS CLA, ( select meaning,lookup_code from HR_LOOKUPS WHERE LOOKUP_TYPE = 'RUN_RESULT_STATUS' ) LO1, PAY_RUN_RESULTS RRS, PAY_ASSIGNMENT_ACTIONS ASACT, PAY_PAYROLL_ACTIONS PACT WHERE ETY.element_type_id = ETYTL.element_type_id AND ETYTL.LANGUAGE = userenv('LANG') AND CLA.Classification_id = CLATL.classification_id AND CLATL.LANGUAGE = userenv('LANG') AND RRS.ELEMENT_TYPE_ID = ETY.ELEMENT_TYPE_ID AND CLA.CLASSIFICATION_ID = ETY.CLASSIFICATION_ID AND LO1.LOOKUP_CODE = RRS.STATUS AND PACT.PAYROLL_ACTION_ID = ASACT.PAYROLL_ACTION_ID AND ASACT.ASSIGNMENT_ACTION_ID = RRS.ASSIGNMENT_ACTION_ID AND PACT.EFFECTIVE_DATE BETWEEN ETY.EFFECTIVE_START_DATE AND ETY.EFFECTIVE_END_DATE AND NOT EXISTS ( SELECT /*+ ORDERED INDEX(INV2 PAY_INPUT_VALUES_F_N50) INDEX(RRV2 PAY_RUN_RESULT_VALUES_PK) USE_NL(INV2 RRV2) */ 1 FROM PAY_INPUT_VALUES_F INV2, PAY_RUN_RESULT_VALUES RRV2 WHERE RRV2.RUN_RESULT_ID = RRS.RUN_RESULT_ID AND RRV2.INPUT_VALUE_ID = INV2.INPUT_VALUE_ID AND INV2.ELEMENT_TYPE_ID = ETY.ELEMENT_TYPE_ID AND PACT.EFFECTIVE_DATE BETWEEN INV2.EFFECTIVE_START_DATE AND INV2.EFFECTIVE_END_DATE AND INV2.NAME = 'Pay Value' )

View Text - HTML Formatted

SELECT /*+ INDEX (RRV PAY_RUN_RESULT_VALUES_PK) */ RRS.ASSIGNMENT_ACTION_ID
, RRS.RUN_RESULT_ID
, ETYTL.ELEMENT_NAME
, HR_GENERAL.START_OF_TIME ELE_START_DATE
, HR_GENERAL.END_OF_TIME ELE_END_DATE
, CLATL.CLASSIFICATION_NAME
, DECODE ( RRS.STATUS
, 'R'
, LO1.MEANING
, 'O'
, LO1.MEANING
, 'PA'
, LO1.MEANING
, NULL ) MODIFIED
, ETY.OUTPUT_CURRENCY_CODE
, RRV.RESULT_VALUE RESULT_VALUE
, HR_GENERAL.START_OF_TIME INV_START_DATE
, HR_GENERAL.END_OF_TIME INV_END_DATE
, INV.UOM UOM
, LO2.MEANING UNITS
, INV.INPUT_VALUE_ID
, RRS.START_DATE
, RRS.END_DATE
, ETY.PROCESSING_PRIORITY PROCESSING_PRIORITY
FROM PAY_ELEMENT_TYPES_F ETY
, PAY_ELEMENT_TYPES_F_TL ETYTL
, PAY_ELEMENT_CLASSIFICATIONS CLA
, PAY_ELEMENT_CLASSIFICATIONS_TL CLATL
, PAY_RUN_RESULT_VALUES RRV
, PAY_INPUT_VALUES_F INV
, PAY_RUN_RESULTS RRS
, ( SELECT MEANING
, LOOKUP_CODE
FROM HR_LOOKUPS
WHERE LOOKUP_TYPE = 'RUN_RESULT_STATUS' ) LO1
, ( SELECT MEANING
, LOOKUP_CODE
FROM HR_LOOKUPS
WHERE LOOKUP_TYPE = 'UNITS' ) LO2
, PAY_ASSIGNMENT_ACTIONS ASACT
, PAY_PAYROLL_ACTIONS PACT
WHERE ETY.ELEMENT_TYPE_ID = ETYTL.ELEMENT_TYPE_ID
AND ETYTL.LANGUAGE = USERENV('LANG')
AND CLA.CLASSIFICATION_ID = CLATL.CLASSIFICATION_ID
AND CLATL.LANGUAGE = USERENV('LANG')
AND INV.ELEMENT_TYPE_ID = ETY.ELEMENT_TYPE_ID
AND RRS.ELEMENT_TYPE_ID = ETY.ELEMENT_TYPE_ID
AND CLA.CLASSIFICATION_ID = ETY.CLASSIFICATION_ID
AND PACT.PAYROLL_ACTION_ID = ASACT.PAYROLL_ACTION_ID
AND ASACT.ASSIGNMENT_ACTION_ID = RRS.ASSIGNMENT_ACTION_ID
AND RRS.RUN_RESULT_ID = RRV.RUN_RESULT_ID
AND RRV.INPUT_VALUE_ID = INV.INPUT_VALUE_ID
AND LO1.LOOKUP_CODE = RRS.STATUS
AND INV.NAME = 'PAY VALUE'
AND LO2.LOOKUP_CODE = INV.UOM
AND PACT.EFFECTIVE_DATE BETWEEN INV.EFFECTIVE_START_DATE
AND INV.EFFECTIVE_END_DATE
AND PACT.EFFECTIVE_DATE BETWEEN ETY.EFFECTIVE_START_DATE
AND ETY.EFFECTIVE_END_DATE UNION SELECT RRS.ASSIGNMENT_ACTION_ID
, RRS.RUN_RESULT_ID
, ETYTL.ELEMENT_NAME
, ETY.EFFECTIVE_START_DATE ELE_START_DATE
, ETY.EFFECTIVE_END_DATE ELE_END_DATE
, CLATL.CLASSIFICATION_NAME
, DECODE ( RRS.STATUS
, 'R'
, LO1.MEANING
, 'O'
, LO1.MEANING
, 'PA'
, LO1.MEANING
, NULL ) MODIFIED
, ETY.OUTPUT_CURRENCY_CODE
, NULL RESULT_VALUE
, FND_DATE.CANONICAL_TO_DATE('0001/01/01') INV_START_DATE
, FND_DATE.CANONICAL_TO_DATE('4712/12/31') INV_END_DATE
, NULL UOM
, NULL UNITS
, FND_NUMBER.CANONICAL_TO_NUMBER(NULL) INPUT_VALUE_ID
, RRS.START_DATE
, RRS.END_DATE
, ETY.PROCESSING_PRIORITY PROCESSING_PRIORITY
FROM PAY_ELEMENT_TYPES_F ETY
, PAY_ELEMENT_TYPES_F_TL ETYTL
, PAY_ELEMENT_CLASSIFICATIONS_TL CLATL
, PAY_ELEMENT_CLASSIFICATIONS CLA
, ( SELECT MEANING
, LOOKUP_CODE
FROM HR_LOOKUPS
WHERE LOOKUP_TYPE = 'RUN_RESULT_STATUS' ) LO1
, PAY_RUN_RESULTS RRS
, PAY_ASSIGNMENT_ACTIONS ASACT
, PAY_PAYROLL_ACTIONS PACT
WHERE ETY.ELEMENT_TYPE_ID = ETYTL.ELEMENT_TYPE_ID
AND ETYTL.LANGUAGE = USERENV('LANG')
AND CLA.CLASSIFICATION_ID = CLATL.CLASSIFICATION_ID
AND CLATL.LANGUAGE = USERENV('LANG')
AND RRS.ELEMENT_TYPE_ID = ETY.ELEMENT_TYPE_ID
AND CLA.CLASSIFICATION_ID = ETY.CLASSIFICATION_ID
AND LO1.LOOKUP_CODE = RRS.STATUS
AND PACT.PAYROLL_ACTION_ID = ASACT.PAYROLL_ACTION_ID
AND ASACT.ASSIGNMENT_ACTION_ID = RRS.ASSIGNMENT_ACTION_ID
AND PACT.EFFECTIVE_DATE BETWEEN ETY.EFFECTIVE_START_DATE
AND ETY.EFFECTIVE_END_DATE
AND NOT EXISTS ( SELECT /*+ ORDERED INDEX(INV2 PAY_INPUT_VALUES_F_N50) INDEX(RRV2 PAY_RUN_RESULT_VALUES_PK) USE_NL(INV2 RRV2) */ 1
FROM PAY_INPUT_VALUES_F INV2
, PAY_RUN_RESULT_VALUES RRV2
WHERE RRV2.RUN_RESULT_ID = RRS.RUN_RESULT_ID
AND RRV2.INPUT_VALUE_ID = INV2.INPUT_VALUE_ID
AND INV2.ELEMENT_TYPE_ID = ETY.ELEMENT_TYPE_ID
AND PACT.EFFECTIVE_DATE BETWEEN INV2.EFFECTIVE_START_DATE
AND INV2.EFFECTIVE_END_DATE
AND INV2.NAME = 'PAY VALUE' )