View: PA_STATUS_EI_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_STATUS_EI_V

View Text

SELECT /*+ LEADING (ACT) NO_MERGE(ACT) */ ACT.EXPENDITURE_ITEM_ID
, ACT.PA_START_DATE
, ACT.PROJECT_ID
, ACT.TASK_ID
, ACT.PA_PERIOD
, ACT.RESOURCE_LIST_MEMBER_ID
, ACT.QUANTITY
, ACT.RAW_COST
, ACT.BURDENED_COST
, ACT.BILLABLE_QUANTITY
, ACT.BILLABLE_RAW_COST
, ACT.BILLABLE_BURDENED_COST
, ACT.REVENUE
, ACT.TASK_NUMBER
, ACT.TASK_NAME
, ACT.EXPENDITURE_ITEM_DATE
, ACT.EXPENDITURE_TYPE
, ACT.EXPENDITURE_CATEGORY
, ACT.REVENUE_CATEGORY_CODE
, ACT.INCURRED_BY_PERSON_ID
, EMP.FULL_NAME EMPLOYEE_NAME
, EMP.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, ACT.JOB_ID
, J.NAME JOB_NAME
, ACT.INCURRED_BY_ORGANIZATION_ID
, ACT.OVERRIDE_TO_ORGANIZATION_ID
, ACT.EXPENDITURE_ORGANIZATION_ID
, ACT.EXPENDITURE_ORGANIZATION_NAME
, VEND.VENDOR_ID
, VEND.SEGMENT1 VENDOR_NUMBER
, VEND.VENDOR_NAME
, NVL(EMP.FULL_NAME
, VEND.VENDOR_NAME) EMPLOYEE_VENDOR_NAME
, NVL(EMP.EMPLOYEE_NUMBER
, VEND.SEGMENT1) EMPLOYEE_VENDOR_NUMBER
, ACT.NON_LABOR_RESOURCE
, ACT.NLR_ORGANIZATION_ID
, OTL.NAME NLR_ORGANIZATION_NAME
, ACT.SYSTEM_LINKAGE_FUNCTION
, ACT.SYSTEM_LINKAGE_M
, C.EXPENDITURE_COMMENT
, ACT.TRANSACTION_SOURCE
, TR.USER_TRANSACTION_SOURCE
, ACT.ORIG_TRANSACTION_REFERENCE
, ACT.EXPENDITURE_GROUP
, ACT.UNIT_OF_MEASURE
, ACT.UNIT_OF_MEASURE_M
, ACT.RECEIPT_CURRENCY_CODE
, ACT.RECEIPT_CURRENCY_AMOUNT
, ACT.RECEIPT_EXCHANGE_RATE
, ACT.DENOM_CURRENCY_CODE
, ACT.DENOM_RAW_COST
, ACT.DENOM_BURDENED_COST
, ACT.ACCT_EXCHANGE_ROUNDING_LIMIT
, ACT.ACCT_CURRENCY_CODE
, ACT.ACCT_RATE_TYPE
, ACT.ACCT_RATE_DATE
, ACT.ACCT_EXCHANGE_RATE
, ACT.ACCT_RAW_COST
, ACT.ACCT_BURDENED_COST
, ACT.PROJECT_CURRENCY_CODE
, ACT.PROJECT_RATE_TYPE
, ACT.PROJECT_RATE_DATE
, ACT.PROJECT_EXCHANGE_RATE
, CDL.SYSTEM_REFERENCE2
, CONV.USER_CONVERSION_TYPE
, CONV2.USER_CONVERSION_TYPE
, ACT.EXPENDITURE_ORG_ID
, ACT.ORG_ID
, CDL.SYSTEM_REFERENCE4
FROM PO_VENDORS VEND
, PA_COST_DIST_LINES_ALL_BAS CDL
, PER_JOBS J
, HR_ALL_ORGANIZATION_UNITS_TL OTL
, PA_EXPENDITURE_COMMENTS C
, PER_ALL_PEOPLE_F EMP
, GL_DAILY_CONVERSION_TYPES CONV
, GL_DAILY_CONVERSION_TYPES CONV2
, PA_TRANSACTION_SOURCES TR
, PA_STATUS_EI_DRIVE_V ACT
WHERE ACT.TRANSACTION_SOURCE = TR.TRANSACTION_SOURCE (+)
AND ACT.NLR_ORGANIZATION_ID = OTL.ORGANIZATION_ID(+)
AND DECODE(OTL.ORGANIZATION_ID
, NULL
, '1'
, OTL.LANGUAGE) = DECODE(OTL.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND ACT.JOB_ID = J.JOB_ID (+)
AND ACT.EXPENDITURE_ITEM_ID = C.EXPENDITURE_ITEM_ID (+)
AND ACT.INCURRED_BY_PERSON_ID = EMP.PERSON_ID (+)
AND TRUNC( SYSDATE ) BETWEEN EMP.EFFECTIVE_START_DATE (+)
AND EMP.EFFECTIVE_END_DATE (+)
AND ACT.EXPENDITURE_ITEM_ID = CDL.EXPENDITURE_ITEM_ID (+)
AND CDL.LINE_NUM (+) = 1
AND CDL.SYSTEM_REFERENCE1 = VEND.VENDOR_ID (+)
AND ACT.ACCT_RATE_TYPE = CONV.CONVERSION_TYPE (+)
AND ACT.PROJECT_RATE_TYPE = CONV2.CONVERSION_TYPE (+)

Columns