VIEW: APPS.PA_STATUS_EI_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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