VIEW: APPS.PA_EXPEND_ITEMS_ADJUST_V

Source

View Text - Preformatted

SELECT EI.ROWID ROW_ID , EI.EXPENDITURE_ITEM_ID , EI.EXPENDITURE_ID , P.PROJECT_ID , P.SEGMENT1 PROJECT_NUMBER , P.NAME PROJECT_NAME , PT.PROJECT_TYPE , PT.PROJECT_TYPE_CLASS_CODE , L8.MEANING PROJECT_CLASS , EI.TASK_ID , T.TASK_NUMBER , T.TASK_NAME , EI.EXPENDITURE_ITEM_DATE , EI.EXPENDITURE_TYPE , ET.EXPENDITURE_CATEGORY , ET.REVENUE_CATEGORY_CODE , X.INCURRED_BY_PERSON_ID , EMP.FULL_NAME EMPLOYEE_NAME , NVL(EMP.EMPLOYEE_NUMBER, EMP.NPW_NUMBER) EMPLOYEE_NUMBER , EI.JOB_ID , J.NAME JOB_NAME , X.INCURRED_BY_ORGANIZATION_ID , EI.OVERRIDE_TO_ORGANIZATION_ID , NVL(EI.OVERRIDE_TO_ORGANIZATION_ID, X.INCURRED_BY_ORGANIZATION_ID) EXPENDITURE_ORGANIZATION_ID , O1.NAME EXPENDITURE_ORGANIZATION_NAME , VEND.VENDOR_ID , VEND.SEGMENT1 VENDOR_NUMBER , VEND.VENDOR_NAME , NVL(EMP.FULL_NAME, VEND.VENDOR_NAME) EMPLOYEE_VENDOR_NAME , NVL( NVL( EMP.EMPLOYEE_NUMBER, EMP.NPW_NUMBER) , VEND.SEGMENT1) EMPLOYEE_VENDOR_NUMBER , EI.NON_LABOR_RESOURCE , EI.ORGANIZATION_ID NLR_ORGANIZATION_ID , O2.NAME NLR_ORGANIZATION_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 , L1.MEANING EXPENDITURE_STATUS_M , X.EXPENDITURE_ENDING_DATE , EI.QUANTITY , EI.BURDEN_COST , NVL(EI.UNIT_OF_MEASURE,ET.UNIT_OF_MEASURE) , L2.MEANING UNIT_OF_MEASURE_M , EI.RAW_COST , EI.RAW_COST_RATE , EI.COST_DISTRIBUTED_FLAG , EI.COST_DIST_REJECTION_CODE , EI.LABOR_COST_MULTIPLIER_NAME , EI.BURDEN_COST BURDENED_COST , EI.BURDEN_COST_RATE BURDENED_COST_RATE , EI.COST_BURDEN_DISTRIBUTED_FLAG , EI.receipt_currency_code , EI.receipt_currency_amount , EI.receipt_exchange_rate , EI.denom_currency_code , EI.denom_raw_cost , EI.denom_burdened_cost , EI.acct_exchange_rounding_limit , EI.acct_currency_code , EI.acct_rate_type , EI.acct_rate_date , EI.acct_exchange_rate , EI.acct_raw_cost , EI.acct_burdened_cost , EI.project_currency_code , EI.project_rate_type , EI.project_rate_date , EI.project_exchange_rate , EI.IND_COST_DIST_REJECTION_CODE , EI.COST_IND_COMPILED_SET_ID , DECODE (PT.PROJECT_TYPE_CLASS_CODE, 'CAPITAL', EI.BILLABLE_FLAG, NULL) CAPITALIZABLE_FLAG , EI.ACCRUED_REVENUE , EI.ACCRUAL_RATE , EI.RAW_REVENUE , EI.FORECAST_REVENUE , EI.BILL_AMOUNT , EI.BILL_RATE , EI.BILL_RATE_MULTIPLIER , EI.ADJUSTED_REVENUE , EI.ADJUSTED_RATE , DECODE (PT.PROJECT_TYPE_CLASS_CODE, 'CAPITAL', NULL, EI.BILLABLE_FLAG) BILLABLE_FLAG , EI.REVENUE_DISTRIBUTED_FLAG , EI.BILL_HOLD_FLAG , EI.REV_DIST_REJECTION_CODE , EI.BILL_JOB_ID , EI.BILL_JOB_BILLING_TITLE , EI.BILL_EMPLOYEE_BILLING_TITLE , EI.REV_IND_COMPILED_SET_ID , EI.INV_IND_COMPILED_SET_ID , EI.PROJECT_ID , EI.EVENT_NUM , EI.EVENT_TASK_ID , 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.LAST_UPDATE_LOGIN , EI.LAST_UPDATE_DATE , EI.LAST_UPDATED_BY , EI.CREATION_DATE , EI.CREATED_BY , EI.ATTRIBUTE_CATEGORY , EI.ATTRIBUTE1 , EI.ATTRIBUTE2 , EI.ATTRIBUTE3 , EI.ATTRIBUTE4 , EI.ATTRIBUTE5 , EI.ATTRIBUTE6 , EI.ATTRIBUTE7 , EI.ATTRIBUTE8 , EI.ATTRIBUTE9 , EI.ATTRIBUTE10 , EI.ORG_ID , CDL.SYSTEM_REFERENCE2 ,P.ORG_ID ,TR.USER_TRANSACTION_SOURCE ,TR.ALLOW_ADJUSTMENTS_FLAG ,TR.COSTED_FLAG ,TR.COST_BURDENED_FLAG ,TR.GL_ACCOUNTED_FLAG ,TR.allow_reversal_flag ,TR.allow_burden_flag ,EI.BURDEN_SUM_DEST_RUN_ID ,CDL.BURDEN_SUM_REJECTION_CODE ,L9.MEANING ,P.PROJECT_STATUS_CODE ,CONV.USER_CONVERSION_TYPE ,CONV2.USER_CONVERSION_TYPE ,X.ORIG_EXP_TXN_REFERENCE1 ,X.ORIG_USER_EXP_TXN_REFERENCE ,X.ORIG_EXP_TXN_REFERENCE2 ,X.ORIG_EXP_TXN_REFERENCE3 ,X.OVERRIDING_APPROVER_PERSON_ID ,X.WF_STATUS_CODE ,X.transfer_status_code ,X.USER_BATCH_NAME ,EI.BILL_TRANS_CURRENCY_CODE ,EI.PROJECT_BILL_AMOUNT ,EI.PROJFUNC_CURRENCY_CODE ,EI.PROJFUNC_BILL_AMOUNT ,EI.INVPROC_CURRENCY_CODE ,EI.INVPROC_RATE_TYPE ,EI.INVPROC_RATE_DATE ,EI.INVPROC_EXCHANGE_RATE ,EI.PROJFUNC_COST_RATE_TYPE ,EI.PROJFUNC_COST_RATE_DATE ,EI.PROJFUNC_COST_EXCHANGE_RATE ,EI.PROJECT_RAW_COST ,EI.PROJECT_BURDENED_COST ,EI.ASSIGNMENT_ID ,EI.WORK_TYPE_ID ,EI.PROJECT_TP_RATE_DATE ,EI.PROJECT_TP_RATE_TYPE ,EI.PROJECT_TP_EXCHANGE_RATE ,EI.PROJECT_TRANSFER_PRICE ,EI.tp_amt_type_code ,EI.PROJFUNC_TP_RATE_DATE ,EI.PROJFUNC_TP_RATE_TYPE ,EI.PROJFUNC_TP_EXCHANGE_RATE ,EI.PROJFUNC_TRANSFER_PRICE ,EI.BILL_TRANS_BILL_AMOUNT ,EI.Prvdr_Accrual_Date ,EI.Recvr_Accrual_Date ,EI.cc_cross_charge_code ,EI.cc_cross_charge_type ,EI.cc_bl_distributed_code ,EI.cc_ic_processed_code ,EI.cc_rejection_code ,EI.org_id ,EI.recvr_org_id ,EI.acct_tp_rate_type ,(select nvl(user_conversion_type,EI.acct_tp_rate_type) from PA_CONVERSION_TYPES_V WHERE conversion_type = EI.acct_tp_rate_type) ,EI.acct_tp_rate_date ,EI.acct_tp_exchange_rate ,(select nvl(user_conversion_type,EI.projfunc_cost_rate_type) from PA_CONVERSION_TYPES_V where CONVERSION_TYPE = EI.PROJFUNC_COST_RATE_TYPE ) ,EI.denom_tp_currency_code , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , EI.DOCUMENT_HEADER_ID , EI.DOCUMENT_LINE_NUMBER , EI.DOCUMENT_DISTRIBUTION_ID , EI.DOCUMENT_TYPE , EI.DOCUMENT_DISTRIBUTION_TYPE , EI.DOCUMENT_PAYMENT_ID FROM PA_PROJECTS_ALL P, PA_PROJECT_TYPES PT, PA_TASKS T, PA_EXPENDITURE_ITEMS_ALL EI, PA_EXPENDITURES_ALL X, HR_ALL_ORGANIZATION_UNITS_TL O1, 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 O2, PA_SYSTEM_LINKAGES SL, PA_EXPENDITURE_COMMENTS C, PER_PEOPLE_F EMP, PA_CONVERSION_TYPES_V CONV, PA_CONVERSION_TYPES_V CONV2, PA_TRANSACTION_SOURCES TR WHERE T.PROJECT_ID = P.PROJECT_ID AND EI.PROJECT_ID = P.PROJECT_ID AND P.PROJECT_TYPE = PT.PROJECT_TYPE AND EI.TASK_ID = T.TASK_ID AND EI.EXPENDITURE_ID = X.EXPENDITURE_ID AND EI.TRANSACTION_SOURCE = TR.TRANSACTION_SOURCE (+) AND NVL(EI.OVERRIDE_TO_ORGANIZATION_ID, X.INCURRED_BY_ORGANIZATION_ID) = O1.ORGANIZATION_ID AND O1.LANGUAGE = USERENV('LANG') AND EI.ORGANIZATION_ID = O2.ORGANIZATION_ID (+) AND O2.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,NULL,'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( NVL( EI.UNIT_OF_MEASURE, ET.UNIT_OF_MEASURE) ,NULL,NULL,'UNIT') AND L2.LOOKUP_CODE = NVL(EI.UNIT_OF_MEASURE, 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,NULL,'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 EI.EXPENDITURE_ITEM_ID = CDL.EXPENDITURE_ITEM_ID (+) AND CDL.LINE_NUM (+) = 1 AND EI.VENDOR_ID = VEND.VENDOR_ID (+) AND EI.ACCT_RATE_TYPE = CONV.CONVERSION_TYPE (+) AND EI.PROJECT_RATE_TYPE = CONV2.CONVERSION_TYPE (+) AND PT.ORG_ID = P.ORG_ID

View Text - HTML Formatted

SELECT EI.ROWID ROW_ID
, EI.EXPENDITURE_ITEM_ID
, EI.EXPENDITURE_ID
, P.PROJECT_ID
, P.SEGMENT1 PROJECT_NUMBER
, P.NAME PROJECT_NAME
, PT.PROJECT_TYPE
, PT.PROJECT_TYPE_CLASS_CODE
, L8.MEANING PROJECT_CLASS
, EI.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, EI.EXPENDITURE_ITEM_DATE
, EI.EXPENDITURE_TYPE
, ET.EXPENDITURE_CATEGORY
, ET.REVENUE_CATEGORY_CODE
, X.INCURRED_BY_PERSON_ID
, EMP.FULL_NAME EMPLOYEE_NAME
, NVL(EMP.EMPLOYEE_NUMBER
, EMP.NPW_NUMBER) EMPLOYEE_NUMBER
, EI.JOB_ID
, J.NAME JOB_NAME
, X.INCURRED_BY_ORGANIZATION_ID
, EI.OVERRIDE_TO_ORGANIZATION_ID
, NVL(EI.OVERRIDE_TO_ORGANIZATION_ID
, X.INCURRED_BY_ORGANIZATION_ID) EXPENDITURE_ORGANIZATION_ID
, O1.NAME EXPENDITURE_ORGANIZATION_NAME
, VEND.VENDOR_ID
, VEND.SEGMENT1 VENDOR_NUMBER
, VEND.VENDOR_NAME
, NVL(EMP.FULL_NAME
, VEND.VENDOR_NAME) EMPLOYEE_VENDOR_NAME
, NVL( NVL( EMP.EMPLOYEE_NUMBER
, EMP.NPW_NUMBER)
, VEND.SEGMENT1) EMPLOYEE_VENDOR_NUMBER
, EI.NON_LABOR_RESOURCE
, EI.ORGANIZATION_ID NLR_ORGANIZATION_ID
, O2.NAME NLR_ORGANIZATION_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
, L1.MEANING EXPENDITURE_STATUS_M
, X.EXPENDITURE_ENDING_DATE
, EI.QUANTITY
, EI.BURDEN_COST
, NVL(EI.UNIT_OF_MEASURE
, ET.UNIT_OF_MEASURE)
, L2.MEANING UNIT_OF_MEASURE_M
, EI.RAW_COST
, EI.RAW_COST_RATE
, EI.COST_DISTRIBUTED_FLAG
, EI.COST_DIST_REJECTION_CODE
, EI.LABOR_COST_MULTIPLIER_NAME
, EI.BURDEN_COST BURDENED_COST
, EI.BURDEN_COST_RATE BURDENED_COST_RATE
, EI.COST_BURDEN_DISTRIBUTED_FLAG
, EI.RECEIPT_CURRENCY_CODE
, EI.RECEIPT_CURRENCY_AMOUNT
, EI.RECEIPT_EXCHANGE_RATE
, EI.DENOM_CURRENCY_CODE
, EI.DENOM_RAW_COST
, EI.DENOM_BURDENED_COST
, EI.ACCT_EXCHANGE_ROUNDING_LIMIT
, EI.ACCT_CURRENCY_CODE
, EI.ACCT_RATE_TYPE
, EI.ACCT_RATE_DATE
, EI.ACCT_EXCHANGE_RATE
, EI.ACCT_RAW_COST
, EI.ACCT_BURDENED_COST
, EI.PROJECT_CURRENCY_CODE
, EI.PROJECT_RATE_TYPE
, EI.PROJECT_RATE_DATE
, EI.PROJECT_EXCHANGE_RATE
, EI.IND_COST_DIST_REJECTION_CODE
, EI.COST_IND_COMPILED_SET_ID
, DECODE (PT.PROJECT_TYPE_CLASS_CODE
, 'CAPITAL'
, EI.BILLABLE_FLAG
, NULL) CAPITALIZABLE_FLAG
, EI.ACCRUED_REVENUE
, EI.ACCRUAL_RATE
, EI.RAW_REVENUE
, EI.FORECAST_REVENUE
, EI.BILL_AMOUNT
, EI.BILL_RATE
, EI.BILL_RATE_MULTIPLIER
, EI.ADJUSTED_REVENUE
, EI.ADJUSTED_RATE
, DECODE (PT.PROJECT_TYPE_CLASS_CODE
, 'CAPITAL'
, NULL
, EI.BILLABLE_FLAG) BILLABLE_FLAG
, EI.REVENUE_DISTRIBUTED_FLAG
, EI.BILL_HOLD_FLAG
, EI.REV_DIST_REJECTION_CODE
, EI.BILL_JOB_ID
, EI.BILL_JOB_BILLING_TITLE
, EI.BILL_EMPLOYEE_BILLING_TITLE
, EI.REV_IND_COMPILED_SET_ID
, EI.INV_IND_COMPILED_SET_ID
, EI.PROJECT_ID
, EI.EVENT_NUM
, EI.EVENT_TASK_ID
, 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.LAST_UPDATE_LOGIN
, EI.LAST_UPDATE_DATE
, EI.LAST_UPDATED_BY
, EI.CREATION_DATE
, EI.CREATED_BY
, EI.ATTRIBUTE_CATEGORY
, EI.ATTRIBUTE1
, EI.ATTRIBUTE2
, EI.ATTRIBUTE3
, EI.ATTRIBUTE4
, EI.ATTRIBUTE5
, EI.ATTRIBUTE6
, EI.ATTRIBUTE7
, EI.ATTRIBUTE8
, EI.ATTRIBUTE9
, EI.ATTRIBUTE10
, EI.ORG_ID
, CDL.SYSTEM_REFERENCE2
, P.ORG_ID
, TR.USER_TRANSACTION_SOURCE
, TR.ALLOW_ADJUSTMENTS_FLAG
, TR.COSTED_FLAG
, TR.COST_BURDENED_FLAG
, TR.GL_ACCOUNTED_FLAG
, TR.ALLOW_REVERSAL_FLAG
, TR.ALLOW_BURDEN_FLAG
, EI.BURDEN_SUM_DEST_RUN_ID
, CDL.BURDEN_SUM_REJECTION_CODE
, L9.MEANING
, P.PROJECT_STATUS_CODE
, CONV.USER_CONVERSION_TYPE
, CONV2.USER_CONVERSION_TYPE
, X.ORIG_EXP_TXN_REFERENCE1
, X.ORIG_USER_EXP_TXN_REFERENCE
, X.ORIG_EXP_TXN_REFERENCE2
, X.ORIG_EXP_TXN_REFERENCE3
, X.OVERRIDING_APPROVER_PERSON_ID
, X.WF_STATUS_CODE
, X.TRANSFER_STATUS_CODE
, X.USER_BATCH_NAME
, EI.BILL_TRANS_CURRENCY_CODE
, EI.PROJECT_BILL_AMOUNT
, EI.PROJFUNC_CURRENCY_CODE
, EI.PROJFUNC_BILL_AMOUNT
, EI.INVPROC_CURRENCY_CODE
, EI.INVPROC_RATE_TYPE
, EI.INVPROC_RATE_DATE
, EI.INVPROC_EXCHANGE_RATE
, EI.PROJFUNC_COST_RATE_TYPE
, EI.PROJFUNC_COST_RATE_DATE
, EI.PROJFUNC_COST_EXCHANGE_RATE
, EI.PROJECT_RAW_COST
, EI.PROJECT_BURDENED_COST
, EI.ASSIGNMENT_ID
, EI.WORK_TYPE_ID
, EI.PROJECT_TP_RATE_DATE
, EI.PROJECT_TP_RATE_TYPE
, EI.PROJECT_TP_EXCHANGE_RATE
, EI.PROJECT_TRANSFER_PRICE
, EI.TP_AMT_TYPE_CODE
, EI.PROJFUNC_TP_RATE_DATE
, EI.PROJFUNC_TP_RATE_TYPE
, EI.PROJFUNC_TP_EXCHANGE_RATE
, EI.PROJFUNC_TRANSFER_PRICE
, EI.BILL_TRANS_BILL_AMOUNT
, EI.PRVDR_ACCRUAL_DATE
, EI.RECVR_ACCRUAL_DATE
, EI.CC_CROSS_CHARGE_CODE
, EI.CC_CROSS_CHARGE_TYPE
, EI.CC_BL_DISTRIBUTED_CODE
, EI.CC_IC_PROCESSED_CODE
, EI.CC_REJECTION_CODE
, EI.ORG_ID
, EI.RECVR_ORG_ID
, EI.ACCT_TP_RATE_TYPE
, (SELECT NVL(USER_CONVERSION_TYPE
, EI.ACCT_TP_RATE_TYPE)
FROM PA_CONVERSION_TYPES_V
WHERE CONVERSION_TYPE = EI.ACCT_TP_RATE_TYPE)
, EI.ACCT_TP_RATE_DATE
, EI.ACCT_TP_EXCHANGE_RATE
, (SELECT NVL(USER_CONVERSION_TYPE
, EI.PROJFUNC_COST_RATE_TYPE)
FROM PA_CONVERSION_TYPES_V
WHERE CONVERSION_TYPE = EI.PROJFUNC_COST_RATE_TYPE )
, EI.DENOM_TP_CURRENCY_CODE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, EI.DOCUMENT_HEADER_ID
, EI.DOCUMENT_LINE_NUMBER
, EI.DOCUMENT_DISTRIBUTION_ID
, EI.DOCUMENT_TYPE
, EI.DOCUMENT_DISTRIBUTION_TYPE
, EI.DOCUMENT_PAYMENT_ID
FROM PA_PROJECTS_ALL P
, PA_PROJECT_TYPES PT
, PA_TASKS T
, PA_EXPENDITURE_ITEMS_ALL EI
, PA_EXPENDITURES_ALL X
, HR_ALL_ORGANIZATION_UNITS_TL O1
, 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 O2
, PA_SYSTEM_LINKAGES SL
, PA_EXPENDITURE_COMMENTS C
, PER_PEOPLE_F EMP
, PA_CONVERSION_TYPES_V CONV
, PA_CONVERSION_TYPES_V CONV2
, PA_TRANSACTION_SOURCES TR
WHERE T.PROJECT_ID = P.PROJECT_ID
AND EI.PROJECT_ID = P.PROJECT_ID
AND P.PROJECT_TYPE = PT.PROJECT_TYPE
AND EI.TASK_ID = T.TASK_ID
AND EI.EXPENDITURE_ID = X.EXPENDITURE_ID
AND EI.TRANSACTION_SOURCE = TR.TRANSACTION_SOURCE (+)
AND NVL(EI.OVERRIDE_TO_ORGANIZATION_ID
, X.INCURRED_BY_ORGANIZATION_ID) = O1.ORGANIZATION_ID
AND O1.LANGUAGE = USERENV('LANG')
AND EI.ORGANIZATION_ID = O2.ORGANIZATION_ID (+)
AND O2.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
, NULL
, '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( NVL( EI.UNIT_OF_MEASURE
, ET.UNIT_OF_MEASURE)
, NULL
, NULL
, 'UNIT')
AND L2.LOOKUP_CODE = NVL(EI.UNIT_OF_MEASURE
, 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
, NULL
, '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 EI.EXPENDITURE_ITEM_ID = CDL.EXPENDITURE_ITEM_ID (+)
AND CDL.LINE_NUM (+) = 1
AND EI.VENDOR_ID = VEND.VENDOR_ID (+)
AND EI.ACCT_RATE_TYPE = CONV.CONVERSION_TYPE (+)
AND EI.PROJECT_RATE_TYPE = CONV2.CONVERSION_TYPE (+)
AND PT.ORG_ID = P.ORG_ID