View: PA_DRAFT_INV_LINE_DETAILS_V

Product:	PA - Projects
Description:	10SC Only
Implementation/DBA Data:	APPS.PA_DRAFT_INV_LINE_DETAILS_V

View Text

SELECT V.ROW_ID
, L.EXPENDITURE_ITEM_ID
, L.LINE_NUM
, L.PROJECT_ID
, L.DRAFT_INVOICE_NUM
, L.DRAFT_INVOICE_ITEM_LINE_NUM
, DECODE(V.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(L.PROJECT_ID)
, 'Y'
, L.RAW_COST
, NULL)
, 'OT'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(L.PROJECT_ID)
, 'Y'
, L.RAW_COST
, NULL)
, L.RAW_COST)
, V.PROJECT_CURRENCY_CODE
, V.PROJECT_RATE_DATE
, V.PROJECT_RATE_TYPE
, V.USER_PROJECT_RATE_TYPE
, V.PROJECT_EXCHANGE_RATE
, DECODE(V.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(L.PROJECT_ID)
, 'Y'
, V.RECEIPT_CURRENCY_AMOUNT
, NULL)
, 'OT'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(L.PROJECT_ID)
, 'Y'
, V.RECEIPT_CURRENCY_AMOUNT
, NULL)
, V.RECEIPT_CURRENCY_AMOUNT)
, V.RECEIPT_CURRENCY_CODE
, V.RECEIPT_EXCHANGE_RATE
, DECODE(V.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(L.PROJECT_ID)
, 'Y'
, V.DENOM_RAW_COST
, NULL)
, 'OT'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(L.PROJECT_ID)
, 'Y'
, V.DENOM_RAW_COST
, NULL)
, V.DENOM_RAW_COST)
, DECODE(V.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(L.PROJECT_ID)
, 'Y'
, V.DENOM_BURDENED_COST
, NULL)
, 'OT'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(L.PROJECT_ID)
, 'Y'
, V.DENOM_BURDENED_COST
, NULL)
, V.DENOM_BURDENED_COST)
, V.DENOM_CURRENCY_CODE
, DECODE(V.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(L.PROJECT_ID)
, 'Y'
, V.ACCT_RAW_COST
, NULL)
, 'OT'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(L.PROJECT_ID)
, 'Y'
, V.ACCT_RAW_COST
, NULL)
, V.ACCT_RAW_COST)
, DECODE(V.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(L.PROJECT_ID)
, 'Y'
, V.ACCT_BURDENED_COST
, NULL)
, 'OT'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(L.PROJECT_ID)
, 'Y'
, V.ACCT_BURDENED_COST
, NULL)
, V.ACCT_BURDENED_COST)
, V.ACCT_CURRENCY_CODE
, V.ACCT_RATE_DATE
, V.ACCT_RATE_TYPE
, V.USER_ACCT_RATE_TYPE
, V.ACCT_EXCHANGE_RATE
, V.ACCT_EXCHANGE_ROUNDING_LIMIT
, L.BILL_AMOUNT
, L.LINE_NUM_REVERSED
, L.REVERSED_FLAG
, V.EXPENDITURE_ID
, V.TASK_ID
, V.TASK_NUMBER
, V.TASK_NAME
, V.EXPENDITURE_ITEM_DATE
, V.EXPENDITURE_TYPE
, V.INCURRED_BY_PERSON_ID
, V.EMPLOYEE_NAME
, V.EMPLOYEE_NUMBER
, V.JOB_ID
, V.JOB_NAME
, V.EXPENDITURE_ORGANIZATION_ID
, V.EXPENDITURE_ORGANIZATION_NAME
, V.VENDOR_ID
, V.VENDOR_NAME
, V.VENDOR_NUMBER
, V.EMPLOYEE_VENDOR_NAME
, V.EMPLOYEE_VENDOR_NUMBER
, V.NON_LABOR_RESOURCE
, V.NLR_ORGANIZATION_ID
, V.NLR_ORGANIZATION_NAME
, V.SYSTEM_LINKAGE_FUNCTION
, V.SYSTEM_LINKAGE_M
, V.EXPENDITURE_COMMENT
, V.TRANSACTION_SOURCE
, V.ORIG_TRANSACTION_REFERENCE
, V.EXPENDITURE_GROUP
, V.EXPENDITURE_STATUS_CODE
, V.QUANTITY
, DECODE(V.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(L.PROJECT_ID)
, 'Y'
, V.BURDEN_COST
, NULL)
, 'OT'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(L.PROJECT_ID)
, 'Y'
, V.BURDEN_COST
, NULL)
, V.BURDEN_COST) /*
, V.BURDEN_COST */
, V.UNIT_OF_MEASURE
, V.UNIT_OF_MEASURE_M
, V.COST_DISTRIBUTED_FLAG
, DECODE(V.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(L.PROJECT_ID)
, 'Y'
, V.RAW_COST_RATE
, NULL)
, 'OT'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(L.PROJECT_ID)
, 'Y'
, V.RAW_COST_RATE
, NULL)
, V.RAW_COST_RATE)
, V.BILL_RATE
, V.BILL_JOB_BILLING_TITLE
, V.BILL_EMPLOYEE_BILLING_TITLE
, V.ADJUSTED_EXPENDITURE_ITEM_ID
, V.NET_ZERO_ADJUSTMENT_FLAG
, V.TRANSFERRED_FROM_EXP_ITEM_ID
, V.CONVERTED_FLAG
, V.SOURCE_EXPENDITURE_ITEM_ID
, V.EVENT_PROJECT_ID
, V.EVENT_TASK_ID
, V.EVENT_NUM
, V.BILLABLE_FLAG
, V.BILL_HOLD_FLAG
, V.REVENUE_DISTRIBUTED_FLAG
, V.LAST_UPDATE_DATE
, V.LAST_UPDATED_BY
, V.LAST_UPDATE_LOGIN
, V.USER_TRANSACTION_SOURCE
, V.ALLOW_ADJUSTMENTS_FLAG
, V.COSTED_FLAG
, V.COST_BURDENED_FLAG
, V.GL_ACCOUNTED_FLAG
, V.BURDEN_SUM_DEST_RUN_ID
, V.BURDEN_SUM_REJECTION_CODE
, V.BURDEN_SUM_REJECTION_M
, V.PROJECT_STATUS_CODE
, V.SYSTEM_REFERENCE2
, 'FROM-RDL'
FROM PA_CUST_REV_DIST_LINES L
, PA_EXPEND_ITEMS_ADJUST_V V
WHERE L.EXPENDITURE_ITEM_ID = V.EXPENDITURE_ITEM_ID
AND L.BILL_AMOUNT IS NOT NULL UNION ALL SELECT V.ROW_ID
, V.EXPENDITURE_ITEM_ID
, TO_NUMBER('')
, V.PROJECT_ID
, TO_NUMBER('')
, TO_NUMBER('')
, DECODE(V.SYSTEM_LINKAGE_FUNCTION
, 'STRAIGHT_TIME'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(V.PROJECT_ID)
, 'Y'
, V.RAW_COST
, NULL)
, 'ALLOCATED_OVERTIME'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(V.PROJECT_ID)
, 'Y'
, V.RAW_COST
, NULL)
, V.RAW_COST)
, V.PROJECT_CURRENCY_CODE
, V.PROJECT_RATE_DATE
, V.PROJECT_RATE_TYPE
, V.USER_PROJECT_RATE_TYPE
, V.PROJECT_EXCHANGE_RATE
, DECODE (V.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(V.PROJECT_ID)
, 'Y'
, V.RECEIPT_CURRENCY_AMOUNT
, NULL)
, 'OT'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(V.PROJECT_ID)
, 'Y'
, V.RECEIPT_CURRENCY_AMOUNT
, NULL)
, V.RECEIPT_CURRENCY_AMOUNT)
, V.RECEIPT_CURRENCY_CODE
, V.RECEIPT_EXCHANGE_RATE
, DECODE(V.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(V.PROJECT_ID)
, 'Y'
, V.DENOM_RAW_COST
, NULL)
, 'OT'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(V.PROJECT_ID)
, 'Y'
, V.DENOM_RAW_COST
, NULL)
, V.DENOM_RAW_COST)
, DECODE(V.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(V.PROJECT_ID)
, 'Y'
, V.DENOM_BURDENED_COST
, NULL)
, 'OT'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(V.PROJECT_ID)
, 'Y'
, V.DENOM_BURDENED_COST
, NULL)
, V.DENOM_BURDENED_COST)
, V.DENOM_CURRENCY_CODE
, DECODE(V.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(V.PROJECT_ID)
, 'Y'
, V.ACCT_RAW_COST
, NULL)
, 'OT'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(V.PROJECT_ID)
, 'Y'
, V.ACCT_RAW_COST
, NULL)
, V.ACCT_RAW_COST)
, DECODE(V.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(V.PROJECT_ID)
, 'Y'
, V.ACCT_BURDENED_COST
, NULL)
, 'OT'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(V.PROJECT_ID)
, 'Y'
, V.ACCT_BURDENED_COST
, NULL)
, V.ACCT_BURDENED_COST)
, V.ACCT_CURRENCY_CODE
, V.ACCT_RATE_DATE
, V.ACCT_RATE_TYPE
, V.USER_ACCT_RATE_TYPE
, V.ACCT_EXCHANGE_RATE
, V.ACCT_EXCHANGE_ROUNDING_LIMIT
, V.BILL_AMOUNT
, TO_NUMBER('')
, ''
, V.EXPENDITURE_ID
, V.TASK_ID
, V.TASK_NUMBER
, V.TASK_NAME
, V.EXPENDITURE_ITEM_DATE
, V.EXPENDITURE_TYPE
, V.INCURRED_BY_PERSON_ID
, V.EMPLOYEE_NAME
, V.EMPLOYEE_NUMBER
, V.JOB_ID
, V.JOB_NAME
, V.EXPENDITURE_ORGANIZATION_ID
, V.EXPENDITURE_ORGANIZATION_NAME
, V.VENDOR_ID
, V.VENDOR_NAME
, V.VENDOR_NUMBER
, V.EMPLOYEE_VENDOR_NAME
, V.EMPLOYEE_VENDOR_NUMBER
, V.NON_LABOR_RESOURCE
, V.NLR_ORGANIZATION_ID
, V.NLR_ORGANIZATION_NAME
, V.SYSTEM_LINKAGE_FUNCTION
, V.SYSTEM_LINKAGE_M
, V.EXPENDITURE_COMMENT
, V.TRANSACTION_SOURCE
, V.ORIG_TRANSACTION_REFERENCE
, V.EXPENDITURE_GROUP
, V.EXPENDITURE_STATUS_CODE
, V.QUANTITY
, DECODE(V.SYSTEM_LINKAGE_FUNCTION
, 'STRAIGHT_TIME'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(V.PROJECT_ID)
, 'Y'
, V.BURDEN_COST
, NULL)
, 'ALLOCATED_OVERTIME'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(V.PROJECT_ID)
, 'Y'
, V.BURDEN_COST
, NULL)
, V.BURDEN_COST) /*
, V.BURDEN_COST */
, V.UNIT_OF_MEASURE
, V.UNIT_OF_MEASURE_M
, V.COST_DISTRIBUTED_FLAG
, DECODE(V.SYSTEM_LINKAGE_FUNCTION
, 'STRAIGHT_TIME'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(V.PROJECT_ID)
, 'Y'
, V.RAW_COST_RATE
, NULL)
, 'ALLOCATED_OVERTIME'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(V.PROJECT_ID)
, 'Y'
, V.RAW_COST_RATE
, NULL)
, V.RAW_COST_RATE)
, V.BILL_RATE
, V.BILL_JOB_BILLING_TITLE
, V.BILL_EMPLOYEE_BILLING_TITLE
, V.ADJUSTED_EXPENDITURE_ITEM_ID
, V.NET_ZERO_ADJUSTMENT_FLAG
, V.TRANSFERRED_FROM_EXP_ITEM_ID
, V.CONVERTED_FLAG
, V.SOURCE_EXPENDITURE_ITEM_ID
, V.EVENT_PROJECT_ID
, V.EVENT_TASK_ID
, V.EVENT_NUM
, V.BILLABLE_FLAG
, V.BILL_HOLD_FLAG
, V.REVENUE_DISTRIBUTED_FLAG
, V.LAST_UPDATE_DATE
, V.LAST_UPDATED_BY
, V.LAST_UPDATE_LOGIN
, V.USER_TRANSACTION_SOURCE
, V.ALLOW_ADJUSTMENTS_FLAG
, V.COSTED_FLAG
, V.COST_BURDENED_FLAG
, V.GL_ACCOUNTED_FLAG
, V.BURDEN_SUM_DEST_RUN_ID
, V.BURDEN_SUM_REJECTION_CODE
, V.BURDEN_SUM_REJECTION_M
, V.PROJECT_STATUS_CODE
, V.SYSTEM_REFERENCE2
, 'FROM-EI'
FROM PA_EXPEND_ITEMS_ADJUST_V V UNION ALL SELECT EI.ROWID
, D.EXPENDITURE_ITEM_ID
, D.LINE_NUM
, D.PROJECT_ID
, D.DRAFT_INVOICE_NUM
, D.DRAFT_INVOICE_LINE_NUM
, TO_NUMBER(NULL) RAW_COST
, EI.PROJECT_CURRENCY_CODE
, EI.PROJECT_RATE_DATE
, EI.PROJECT_RATE_TYPE
, CONV2.USER_CONVERSION_TYPE
, EI.PROJECT_EXCHANGE_RATE
, DECODE(EI.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(D.PROJECT_ID)
, 'Y'
, EI.RECEIPT_CURRENCY_AMOUNT
, NULL)
, 'OT'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(D.PROJECT_ID)
, 'Y'
, EI.RECEIPT_CURRENCY_AMOUNT
, NULL)
, EI.RECEIPT_CURRENCY_AMOUNT)
, EI.RECEIPT_CURRENCY_CODE
, EI.RECEIPT_EXCHANGE_RATE
, DECODE(EI.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(D.PROJECT_ID)
, 'Y'
, EI.DENOM_RAW_COST
, NULL)
, 'OT'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(D.PROJECT_ID)
, 'Y'
, EI.DENOM_RAW_COST
, NULL)
, EI.DENOM_RAW_COST)
, DECODE(EI.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(D.PROJECT_ID)
, 'Y'
, EI.DENOM_BURDENED_COST
, NULL)
, 'OT'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(D.PROJECT_ID)
, 'Y'
, EI.DENOM_BURDENED_COST
, NULL)
, EI.DENOM_BURDENED_COST)
, EI.DENOM_CURRENCY_CODE
, DECODE(EI.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(D.PROJECT_ID)
, 'Y'
, EI.ACCT_RAW_COST
, NULL)
, 'OT'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(D.PROJECT_ID)
, 'Y'
, EI.ACCT_RAW_COST
, NULL)
, EI.ACCT_RAW_COST)
, DECODE(EI.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(D.PROJECT_ID)
, 'Y'
, EI.ACCT_BURDENED_COST
, NULL)
, 'OT'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(D.PROJECT_ID)
, 'Y'
, EI.ACCT_BURDENED_COST
, NULL)
, EI.ACCT_BURDENED_COST)
, EI.ACCT_CURRENCY_CODE
, EI.ACCT_RATE_DATE
, EI.ACCT_RATE_TYPE
, CONV.USER_CONVERSION_TYPE
, EI.ACCT_EXCHANGE_RATE
, EI.ACCT_EXCHANGE_ROUNDING_LIMIT
, D.BILL_AMOUNT
, D.LINE_NUM_REVERSED
, D.REVERSED_FLAG
, EI.EXPENDITURE_ID
, EI.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, EI.EXPENDITURE_ITEM_DATE
, EI.EXPENDITURE_TYPE
, X.INCURRED_BY_PERSON_ID
, EMP.FULL_NAME
, EMP.EMPLOYEE_NUMBER
, EI.JOB_ID
, J.NAME JOB_NAME
, NVL(EI.OVERRIDE_TO_ORGANIZATION_ID
, X.INCURRED_BY_ORGANIZATION_ID)
, OTL1.NAME
, VEND.VENDOR_ID
, VEND.VENDOR_NAME
, VEND.SEGMENT1
, NVL(EMP.FULL_NAME
, VEND.VENDOR_NAME)
, NVL(EMP.EMPLOYEE_NUMBER
, VEND.SEGMENT1)
, EI.NON_LABOR_RESOURCE
, EI.ORGANIZATION_ID
, OTL2.NAME
, EI.SYSTEM_LINKAGE_FUNCTION
, SL.MEANING SYSTEM_LINKAGE_M
, C.EXPENDITURE_COMMENT
, EI.TRANSACTION_SOURCE
, EI.ORIG_TRANSACTION_REFERENCE
, X.EXPENDITURE_GROUP
, X.EXPENDITURE_STATUS_CODE
, EI.QUANTITY
, DECODE(EI.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(D.PROJECT_ID)
, 'Y'
, EI.BURDEN_COST
, NULL)
, 'OT'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(D.PROJECT_ID)
, 'Y'
, EI.BURDEN_COST
, NULL)
, EI.BURDEN_COST) /*
, EI.BURDEN_COST */
, ET.UNIT_OF_MEASURE
, L2.MEANING
, EI.COST_DISTRIBUTED_FLAG
, DECODE(EI.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(D.PROJECT_ID)
, 'Y'
, EI.RAW_COST_RATE
, NULL)
, 'OT'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(D.PROJECT_ID)
, 'Y'
, EI.RAW_COST_RATE
, NULL)
, EI.RAW_COST_RATE)
, NVL(D.BILL_RATE
, D.BILL_AMOUNT/DECODE(EI.QUANTITY
, 0
, D.BILL_AMOUNT
, EI.QUANTITY)) BILL_RATE
, EI.BILL_JOB_BILLING_TITLE
, EI.BILL_EMPLOYEE_BILLING_TITLE
, EI.ADJUSTED_EXPENDITURE_ITEM_ID
, EI.NET_ZERO_ADJUSTMENT_FLAG
, EI.TRANSFERRED_FROM_EXP_ITEM_ID
, EI.CONVERTED_FLAG
, EI.SOURCE_EXPENDITURE_ITEM_ID
, EI.PROJECT_ID
, EI.EVENT_TASK_ID
, EI.EVENT_NUM
, DECODE (PT.PROJECT_TYPE_CLASS_CODE
, 'CAPITAL'
, NULL
, EI.BILLABLE_FLAG)
, EI.BILL_HOLD_FLAG
, EI.REVENUE_DISTRIBUTED_FLAG
, EI.LAST_UPDATE_DATE
, EI.LAST_UPDATED_BY
, EI.LAST_UPDATE_LOGIN
, TR.USER_TRANSACTION_SOURCE
, TR.ALLOW_ADJUSTMENTS_FLAG
, TR.COSTED_FLAG
, TR.COST_BURDENED_FLAG
, TR.GL_ACCOUNTED_FLAG
, EI.BURDEN_SUM_DEST_RUN_ID
, CDL.BURDEN_SUM_REJECTION_CODE
, L9.MEANING
, P.PROJECT_STATUS_CODE
, CDL.SYSTEM_REFERENCE2
, 'FROM-RDL'
FROM PA_DRAFT_INVOICE_DETAILS D
, PA_EXPENDITURE_ITEMS_ALL EI
, PA_PROJECTS_ALL P
, PA_TASKS T
, PA_EXPENDITURE_TYPES ET
, PO_VENDORS VEND
, PA_COST_DIST_LINES_ALL_BAS CDL
, FND_LOOKUP_VALUES L1
, FND_LOOKUP_VALUES L2
, FND_LOOKUP_VALUES L8
, FND_LOOKUP_VALUES L9
, PER_JOBS J
, HR_ALL_ORGANIZATION_UNITS_TL OTL1
, HR_ALL_ORGANIZATION_UNITS_TL OTL2
, PA_SYSTEM_LINKAGES SL
, PA_EXPENDITURE_COMMENTS C
, PER_PEOPLE_F EMP
, PA_PROJECT_TYPES_ALL PT
, PA_EXPENDITURES_ALL X
, PA_CONVERSION_TYPES_V CONV
, PA_CONVERSION_TYPES_V CONV2
, PA_TRANSACTION_SOURCES TR
WHERE D.EXPENDITURE_ITEM_ID = EI.EXPENDITURE_ITEM_ID
AND EI.TASK_ID = T.TASK_ID
AND T.PROJECT_ID = P.PROJECT_ID
AND P.PROJECT_TYPE = PT.PROJECT_TYPE
AND EI.EXPENDITURE_ID = X.EXPENDITURE_ID
AND EI.TRANSACTION_SOURCE = TR.TRANSACTION_SOURCE (+)
AND OTL1.ORGANIZATION_ID = NVL(EI.OVERRIDE_TO_ORGANIZATION_ID
, X.INCURRED_BY_ORGANIZATION_ID)
AND OTL1.LANGUAGE = USERENV('LANG')
AND EI.ORGANIZATION_ID = OTL2.ORGANIZATION_ID (+)
AND OTL2.LANGUAGE (+) = USERENV('LANG')
AND SL.FUNCTION = EI.SYSTEM_LINKAGE_FUNCTION
AND EI.JOB_ID = J.JOB_ID (+)
AND L1.LOOKUP_TYPE = DECODE(X.EXPENDITURE_STATUS_CODE
, NULL
, 'EXPENDITURE STATUS'
, 'EXPENDITURE STATUS')
AND L1.LOOKUP_CODE = X.EXPENDITURE_STATUS_CODE
AND L1.VIEW_APPLICATION_ID = 275
AND L1.LANGUAGE = USERENV('LANG')
AND L2.LOOKUP_TYPE = DECODE(ET.UNIT_OF_MEASURE
, NULL
, 'UNIT'
, 'UNIT')
AND L2.LOOKUP_CODE = ET.UNIT_OF_MEASURE
AND L2.VIEW_APPLICATION_ID = 275
AND L2.LANGUAGE = USERENV('LANG')
AND L8.LOOKUP_TYPE = DECODE(PT.PROJECT_TYPE_CLASS_CODE
, NULL
, 'PROJECT TYPE CLASS'
, 'PROJECT TYPE CLASS')
AND L8.LOOKUP_CODE = PT.PROJECT_TYPE_CLASS_CODE
AND L8.VIEW_APPLICATION_ID = 275
AND L8.LANGUAGE = USERENV('LANG')
AND L9.LOOKUP_TYPE (+) = 'BURDEN SUM REJECTION CODE'
AND L9.LOOKUP_CODE (+) = CDL.BURDEN_SUM_REJECTION_CODE
AND L9.VIEW_APPLICATION_ID (+) = 275
AND L9.LANGUAGE (+) = USERENV('LANG')
AND EI.EXPENDITURE_TYPE = ET.EXPENDITURE_TYPE
AND EI.EXPENDITURE_ITEM_ID = C.EXPENDITURE_ITEM_ID (+)
AND X.INCURRED_BY_PERSON_ID = EMP.PERSON_ID (+)
AND TRUNC( SYSDATE ) BETWEEN EMP.EFFECTIVE_START_DATE (+)
AND EMP.EFFECTIVE_END_DATE (+)
AND EMP.EMPLOYEE_NUMBER (+) IS NOT NULL
AND EI.EXPENDITURE_ITEM_ID = CDL.EXPENDITURE_ITEM_ID (+)
AND CDL.LINE_NUM (+) = 1
AND CDL.SYSTEM_REFERENCE1 = VEND.VENDOR_ID (+)
AND EI.ACCT_RATE_TYPE = CONV.CONVERSION_TYPE (+)
AND EI.PROJECT_RATE_TYPE = CONV2.CONVERSION_TYPE (+)

Columns