VIEW: APPS.PA_RESOURCE_TXN_ATTRIBUTES_V

Source

View Text - Preformatted

SELECT RTA.ROWID , RTA.RESOURCE_TXN_ATTRIBUTE_ID , R.RESOURCE_ID , E.PERSON_ID , E.FULL_NAME , J.JOB_ID , J.NAME , O.ORGANIZATION_ID , OT.NAME , V.VENDOR_ID , V.VENDOR_NAME , ET.EXPENDITURE_TYPE , EV.EVENT_TYPE , NLR.NON_LABOR_RESOURCE , EC.EXPENDITURE_CATEGORY , RC.REVENUE_CATEGORY_CODE , NLRO.ORGANIZATION_ID , NLROT.NAME , EVTC.EVENT_TYPE_CLASSIFICATION , SL.SYSTEM_LINKAGE_FUNCTION , SL.MEANING , RTA.RESOURCE_FORMAT_ID , RTA.LAST_UPDATE_DATE , RTA.LAST_UPDATED_BY , RTA.CREATION_DATE , RTA.CREATED_BY , RTA.LAST_UPDATE_LOGIN FROM PA_RESOURCE_TXN_ATTRIBUTES RTA, PA_RESOURCES R, PER_PEOPLE_F E, PA_JOBS_V J, HR_ORG_UNITS_NO_JOIN O, HR_ALL_ORGANIZATION_UNITS_TL OT, PO_VENDORS V, PA_EXPENDITURE_TYPES ET, PA_EVENT_TYPES EV, PA_NON_LABOR_RESOURCES NLR, PA_EXPENDITURE_CATEGORIES EC, PA_REVENUE_CATEGORIES_V RC, HR_ORG_UNITS_NO_JOIN NLRO, HR_ALL_ORGANIZATION_UNITS_TL NLROT, PA_EVENT_TYPE_CLASSES_V EVTC, PA_SYSTEM_LINKAGES_V SL WHERE RTA.RESOURCE_ID = R.RESOURCE_ID AND RTA.PERSON_ID = E.PERSON_ID (+) AND TRUNC(SYSDATE) BETWEEN E.EFFECTIVE_START_DATE (+) AND E.EFFECTIVE_END_DATE (+) AND E.EMPLOYEE_NUMBER (+) IS NOT NULL AND RTA.JOB_ID = J.JOB_ID (+) AND RTA.ORGANIZATION_ID = O.ORGANIZATION_ID (+) AND O.ORGANIZATION_ID = OT.ORGANIZATION_ID (+) AND DECODE(OT.ORGANIZATION_ID,NULL,'1',OT.LANGUAGE) = DECODE(OT.ORGANIZATION_ID,NULL,'1',userenv('lang')) AND RTA.VENDOR_ID = V.VENDOR_ID (+) AND RTA.EXPENDITURE_TYPE = ET.EXPENDITURE_TYPE (+) AND RTA.EVENT_TYPE = EV.EVENT_TYPE (+) AND RTA.NON_LABOR_RESOURCE = NLR.NON_LABOR_RESOURCE (+) AND RTA.EXPENDITURE_CATEGORY = EC.EXPENDITURE_CATEGORY (+) AND RTA.REVENUE_CATEGORY = RC.REVENUE_CATEGORY_CODE (+) AND RTA.NON_LABOR_RESOURCE_ORG_ID = NLRO.ORGANIZATION_ID (+) AND NLRO.ORGANIZATION_ID = NLROT.ORGANIZATION_ID (+) AND DECODE(NLROT.ORGANIZATION_ID,NULL,'1',NLROT.LANGUAGE) = DECODE(NLROT.ORGANIZATION_ID,NULL,'1',userenv('lang')) AND RTA.EVENT_TYPE_CLASSIFICATION = EVTC.EVENT_TYPE_CLASSIFICATION AND RTA.SYSTEM_LINKAGE_FUNCTION = SL.SYSTEM_LINKAGE_FUNCTION (+)

View Text - HTML Formatted

SELECT RTA.ROWID
, RTA.RESOURCE_TXN_ATTRIBUTE_ID
, R.RESOURCE_ID
, E.PERSON_ID
, E.FULL_NAME
, J.JOB_ID
, J.NAME
, O.ORGANIZATION_ID
, OT.NAME
, V.VENDOR_ID
, V.VENDOR_NAME
, ET.EXPENDITURE_TYPE
, EV.EVENT_TYPE
, NLR.NON_LABOR_RESOURCE
, EC.EXPENDITURE_CATEGORY
, RC.REVENUE_CATEGORY_CODE
, NLRO.ORGANIZATION_ID
, NLROT.NAME
, EVTC.EVENT_TYPE_CLASSIFICATION
, SL.SYSTEM_LINKAGE_FUNCTION
, SL.MEANING
, RTA.RESOURCE_FORMAT_ID
, RTA.LAST_UPDATE_DATE
, RTA.LAST_UPDATED_BY
, RTA.CREATION_DATE
, RTA.CREATED_BY
, RTA.LAST_UPDATE_LOGIN
FROM PA_RESOURCE_TXN_ATTRIBUTES RTA
, PA_RESOURCES R
, PER_PEOPLE_F E
, PA_JOBS_V J
, HR_ORG_UNITS_NO_JOIN O
, HR_ALL_ORGANIZATION_UNITS_TL OT
, PO_VENDORS V
, PA_EXPENDITURE_TYPES ET
, PA_EVENT_TYPES EV
, PA_NON_LABOR_RESOURCES NLR
, PA_EXPENDITURE_CATEGORIES EC
, PA_REVENUE_CATEGORIES_V RC
, HR_ORG_UNITS_NO_JOIN NLRO
, HR_ALL_ORGANIZATION_UNITS_TL NLROT
, PA_EVENT_TYPE_CLASSES_V EVTC
, PA_SYSTEM_LINKAGES_V SL
WHERE RTA.RESOURCE_ID = R.RESOURCE_ID
AND RTA.PERSON_ID = E.PERSON_ID (+)
AND TRUNC(SYSDATE) BETWEEN E.EFFECTIVE_START_DATE (+)
AND E.EFFECTIVE_END_DATE (+)
AND E.EMPLOYEE_NUMBER (+) IS NOT NULL
AND RTA.JOB_ID = J.JOB_ID (+)
AND RTA.ORGANIZATION_ID = O.ORGANIZATION_ID (+)
AND O.ORGANIZATION_ID = OT.ORGANIZATION_ID (+)
AND DECODE(OT.ORGANIZATION_ID
, NULL
, '1'
, OT.LANGUAGE) = DECODE(OT.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND RTA.VENDOR_ID = V.VENDOR_ID (+)
AND RTA.EXPENDITURE_TYPE = ET.EXPENDITURE_TYPE (+)
AND RTA.EVENT_TYPE = EV.EVENT_TYPE (+)
AND RTA.NON_LABOR_RESOURCE = NLR.NON_LABOR_RESOURCE (+)
AND RTA.EXPENDITURE_CATEGORY = EC.EXPENDITURE_CATEGORY (+)
AND RTA.REVENUE_CATEGORY = RC.REVENUE_CATEGORY_CODE (+)
AND RTA.NON_LABOR_RESOURCE_ORG_ID = NLRO.ORGANIZATION_ID (+)
AND NLRO.ORGANIZATION_ID = NLROT.ORGANIZATION_ID (+)
AND DECODE(NLROT.ORGANIZATION_ID
, NULL
, '1'
, NLROT.LANGUAGE) = DECODE(NLROT.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND RTA.EVENT_TYPE_CLASSIFICATION = EVTC.EVENT_TYPE_CLASSIFICATION
AND RTA.SYSTEM_LINKAGE_FUNCTION = SL.SYSTEM_LINKAGE_FUNCTION (+)