View: PA_RESOURCE_TXN_ATTRIBUTES_V

Product:	PA - Projects
Description:	10Sc only
Implementation/DBA Data:	APPS.PA_RESOURCE_TXN_ATTRIBUTES_V

View Text

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 (+)

Columns