VIEW: APPS.PA_EXPENDITURE_ITEMS_V

Source

View Text - Preformatted

SELECT E.ROWID ROW_ID , E.EXPENDITURE_ITEM_ID , E.EXPENDITURE_ID , T.PROJECT_ID , P.SEGMENT1 PROJECT_NUMBER , P.NAME PROJECT_NAME , E.TASK_ID , T.TASK_NUMBER , T.TASK_NAME , T.DESCRIPTION , OTL.NAME NLR_ORGANIZATION_NAME , X.EXPENDITURE_GROUP , X.EXPENDITURE_STATUS_CODE , X.INCURRED_BY_PERSON_ID , L.MEANING UNIT_OF_MEASURE_M , E.SYSTEM_LINKAGE_FUNCTION , E.EXPENDITURE_ITEM_DATE , E.EXPENDITURE_TYPE , C.EXPENDITURE_COMMENT , E.COST_DISTRIBUTED_FLAG , E.REVENUE_DISTRIBUTED_FLAG , E.BILLABLE_FLAG , E.BILL_HOLD_FLAG , E.QUANTITY , E.NON_LABOR_RESOURCE , E.ORGANIZATION_ID , E.OVERRIDE_TO_ORGANIZATION_ID , E.RAW_COST , E.RAW_COST_RATE , E.BURDEN_COST , E.BURDEN_COST_RATE , E.COST_DIST_REJECTION_CODE , E.LABOR_COST_MULTIPLIER_NAME , E.RAW_REVENUE , E.BILL_RATE , E.ACCRUED_REVENUE , E.ACCRUAL_RATE , E.ADJUSTED_REVENUE , E.ADJUSTED_RATE , E.BILL_AMOUNT , E.FORECAST_REVENUE , E.BILL_RATE_MULTIPLIER , E.REV_DIST_REJECTION_CODE , E.EVENT_NUM , E.EVENT_TASK_ID , E.BILL_JOB_ID , E.BILL_JOB_BILLING_TITLE , E.BILL_EMPLOYEE_BILLING_TITLE , E.ADJUSTED_EXPENDITURE_ITEM_ID , E.NET_ZERO_ADJUSTMENT_FLAG , E.TRANSFERRED_FROM_EXP_ITEM_ID , E.CONVERTED_FLAG , E.LAST_UPDATE_LOGIN , E.LAST_UPDATE_DATE , E.LAST_UPDATED_BY , E.CREATION_DATE , E.CREATED_BY , E.ATTRIBUTE_CATEGORY , E.ATTRIBUTE1 , E.ATTRIBUTE2 , E.ATTRIBUTE3 , E.ATTRIBUTE4 , E.ATTRIBUTE5 , E.ATTRIBUTE6 , E.ATTRIBUTE7 , E.ATTRIBUTE8 , E.ATTRIBUTE9 , E.ATTRIBUTE10 , E.COST_IND_COMPILED_SET_ID , E.REV_IND_COMPILED_SET_ID , E.INV_IND_COMPILED_SET_ID , E.COST_BURDEN_DISTRIBUTED_FLAG , E.IND_COST_DIST_REJECTION_CODE , E.ORIG_TRANSACTION_REFERENCE , E.TRANSACTION_SOURCE , E.SOURCE_EXPENDITURE_ITEM_ID , E.JOB_ID , TR.USER_TRANSACTION_SOURCE , E.BURDEN_SUM_DEST_RUN_ID , E.receipt_currency_amount , E.receipt_currency_code , E.receipt_exchange_rate , E.denom_currency_code , E.denom_raw_cost , E.denom_burdened_cost , E.acct_exchange_rounding_limit , E.acct_currency_code , E.acct_rate_date , E.acct_rate_type , E.acct_exchange_rate , E.acct_raw_cost , E.acct_burdened_cost , E.project_currency_code , E.project_rate_date , E.project_rate_type , E.project_exchange_rate , ET.cost_rate_flag , X.incurred_by_organization_id , TR.ALLOW_REVERSAL_FLAG , P.Org_Id , E.cost_job_id , E.prov_proj_bill_job_id , E.tp_job_id , E.projfunc_currency_code , E.projfunc_bill_amount , E.project_bill_amount , E.projfunc_raw_revenue , E.project_raw_revenue , E.PROJFUNC_COST_RATE_TYPE , E.PROJFUNC_COST_RATE_DATE , E.PROJFUNC_COST_EXCHANGE_RATE , E.PROJECT_RAW_COST , E.PROJECT_BURDENED_COST , E.ASSIGNMENT_ID , E.WORK_TYPE_ID , E.tp_amt_type_code , pa_utils4.get_work_type_name(E.WORK_TYPE_ID) , pa_utils4.get_assignment_name(E.ASSIGNMENT_ID) , E.prvdr_accrual_date , E.recvr_accrual_date , E.capital_event_id , E.po_line_id , E.po_price_type , (select h.segment1  FROM PO_HEADERS_ALL H,PO_LINES_ALL L WHERE l.po_header_id = h.po_header_id and l.po_line_id = e.po_line_id) po_number , (select l.line_num from po_lines_all l where l.po_line_id = e.po_line_id) po_line_number , (select f.meaning from fnd_lookups f where f.lookup_type = 'PRICE DIFFERENTIALS' and f.lookup_code = e.po_price_type) po_price_type_m , wip_resource_id , inventory_item_id , DECODE(E.UNIT_OF_MEASURE, NULL,ET.UNIT_OF_MEASURE,E.UNIT_OF_MEASURE) Unit_of_measure , E.document_header_id , E.document_distribution_id , E.document_line_number , E.document_payment_id , E.document_type , E.document_distribution_type , E.vendor_id FROM PA_LOOKUPS L, PA_EXPENDITURE_TYPES ET, PA_EXPENDITURES X, HR_ORG_UNITS_NO_JOIN O, HR_ALL_ORGANIZATION_UNITS_TL OTL, PA_TASKS T, PA_PROJECTS_ALL P, PA_EXPENDITURE_COMMENTS C, PA_TRANSACTION_SOURCES TR, PA_EXPENDITURE_ITEMS E WHERE T.PROJECT_ID = P.PROJECT_ID AND E.TASK_ID = T.TASK_ID AND E.ORGANIZATION_ID = O.ORGANIZATION_ID (+) AND O.ORGANIZATION_ID = OTL.ORGANIZATION_ID(+) AND DECODE(OTL.ORGANIZATION_ID,NULL,'1',OTL.LANGUAGE) = DECODE(OTL.ORGANIZATION_ID,NULL,'1',USERENV('LANG')) AND E.EXPENDITURE_ID = X.EXPENDITURE_ID AND E.EXPENDITURE_TYPE = ET.EXPENDITURE_TYPE AND E.EXPENDITURE_ITEM_ID = C.EXPENDITURE_ITEM_ID (+) AND E.TRANSACTION_SOURCE = TR.TRANSACTION_SOURCE (+) AND DECODE(E.UNIT_OF_MEASURE, NULL,ET.UNIT_OF_MEASURE,E.UNIT_OF_MEASURE) = L.LOOKUP_CODE AND L.LOOKUP_TYPE = 'UNIT'

View Text - HTML Formatted

SELECT E.ROWID ROW_ID
, E.EXPENDITURE_ITEM_ID
, E.EXPENDITURE_ID
, T.PROJECT_ID
, P.SEGMENT1 PROJECT_NUMBER
, P.NAME PROJECT_NAME
, E.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, T.DESCRIPTION
, OTL.NAME NLR_ORGANIZATION_NAME
, X.EXPENDITURE_GROUP
, X.EXPENDITURE_STATUS_CODE
, X.INCURRED_BY_PERSON_ID
, L.MEANING UNIT_OF_MEASURE_M
, E.SYSTEM_LINKAGE_FUNCTION
, E.EXPENDITURE_ITEM_DATE
, E.EXPENDITURE_TYPE
, C.EXPENDITURE_COMMENT
, E.COST_DISTRIBUTED_FLAG
, E.REVENUE_DISTRIBUTED_FLAG
, E.BILLABLE_FLAG
, E.BILL_HOLD_FLAG
, E.QUANTITY
, E.NON_LABOR_RESOURCE
, E.ORGANIZATION_ID
, E.OVERRIDE_TO_ORGANIZATION_ID
, E.RAW_COST
, E.RAW_COST_RATE
, E.BURDEN_COST
, E.BURDEN_COST_RATE
, E.COST_DIST_REJECTION_CODE
, E.LABOR_COST_MULTIPLIER_NAME
, E.RAW_REVENUE
, E.BILL_RATE
, E.ACCRUED_REVENUE
, E.ACCRUAL_RATE
, E.ADJUSTED_REVENUE
, E.ADJUSTED_RATE
, E.BILL_AMOUNT
, E.FORECAST_REVENUE
, E.BILL_RATE_MULTIPLIER
, E.REV_DIST_REJECTION_CODE
, E.EVENT_NUM
, E.EVENT_TASK_ID
, E.BILL_JOB_ID
, E.BILL_JOB_BILLING_TITLE
, E.BILL_EMPLOYEE_BILLING_TITLE
, E.ADJUSTED_EXPENDITURE_ITEM_ID
, E.NET_ZERO_ADJUSTMENT_FLAG
, E.TRANSFERRED_FROM_EXP_ITEM_ID
, E.CONVERTED_FLAG
, E.LAST_UPDATE_LOGIN
, E.LAST_UPDATE_DATE
, E.LAST_UPDATED_BY
, E.CREATION_DATE
, E.CREATED_BY
, E.ATTRIBUTE_CATEGORY
, E.ATTRIBUTE1
, E.ATTRIBUTE2
, E.ATTRIBUTE3
, E.ATTRIBUTE4
, E.ATTRIBUTE5
, E.ATTRIBUTE6
, E.ATTRIBUTE7
, E.ATTRIBUTE8
, E.ATTRIBUTE9
, E.ATTRIBUTE10
, E.COST_IND_COMPILED_SET_ID
, E.REV_IND_COMPILED_SET_ID
, E.INV_IND_COMPILED_SET_ID
, E.COST_BURDEN_DISTRIBUTED_FLAG
, E.IND_COST_DIST_REJECTION_CODE
, E.ORIG_TRANSACTION_REFERENCE
, E.TRANSACTION_SOURCE
, E.SOURCE_EXPENDITURE_ITEM_ID
, E.JOB_ID
, TR.USER_TRANSACTION_SOURCE
, E.BURDEN_SUM_DEST_RUN_ID
, E.RECEIPT_CURRENCY_AMOUNT
, E.RECEIPT_CURRENCY_CODE
, E.RECEIPT_EXCHANGE_RATE
, E.DENOM_CURRENCY_CODE
, E.DENOM_RAW_COST
, E.DENOM_BURDENED_COST
, E.ACCT_EXCHANGE_ROUNDING_LIMIT
, E.ACCT_CURRENCY_CODE
, E.ACCT_RATE_DATE
, E.ACCT_RATE_TYPE
, E.ACCT_EXCHANGE_RATE
, E.ACCT_RAW_COST
, E.ACCT_BURDENED_COST
, E.PROJECT_CURRENCY_CODE
, E.PROJECT_RATE_DATE
, E.PROJECT_RATE_TYPE
, E.PROJECT_EXCHANGE_RATE
, ET.COST_RATE_FLAG
, X.INCURRED_BY_ORGANIZATION_ID
, TR.ALLOW_REVERSAL_FLAG
, P.ORG_ID
, E.COST_JOB_ID
, E.PROV_PROJ_BILL_JOB_ID
, E.TP_JOB_ID
, E.PROJFUNC_CURRENCY_CODE
, E.PROJFUNC_BILL_AMOUNT
, E.PROJECT_BILL_AMOUNT
, E.PROJFUNC_RAW_REVENUE
, E.PROJECT_RAW_REVENUE
, E.PROJFUNC_COST_RATE_TYPE
, E.PROJFUNC_COST_RATE_DATE
, E.PROJFUNC_COST_EXCHANGE_RATE
, E.PROJECT_RAW_COST
, E.PROJECT_BURDENED_COST
, E.ASSIGNMENT_ID
, E.WORK_TYPE_ID
, E.TP_AMT_TYPE_CODE
, PA_UTILS4.GET_WORK_TYPE_NAME(E.WORK_TYPE_ID)
, PA_UTILS4.GET_ASSIGNMENT_NAME(E.ASSIGNMENT_ID)
, E.PRVDR_ACCRUAL_DATE
, E.RECVR_ACCRUAL_DATE
, E.CAPITAL_EVENT_ID
, E.PO_LINE_ID
, E.PO_PRICE_TYPE
, (SELECT H.SEGMENT1
FROM PO_HEADERS_ALL H
, PO_LINES_ALL L
WHERE L.PO_HEADER_ID = H.PO_HEADER_ID
AND L.PO_LINE_ID = E.PO_LINE_ID) PO_NUMBER
, (SELECT L.LINE_NUM
FROM PO_LINES_ALL L
WHERE L.PO_LINE_ID = E.PO_LINE_ID) PO_LINE_NUMBER
, (SELECT F.MEANING
FROM FND_LOOKUPS F
WHERE F.LOOKUP_TYPE = 'PRICE DIFFERENTIALS'
AND F.LOOKUP_CODE = E.PO_PRICE_TYPE) PO_PRICE_TYPE_M
, WIP_RESOURCE_ID
, INVENTORY_ITEM_ID
, DECODE(E.UNIT_OF_MEASURE
, NULL
, ET.UNIT_OF_MEASURE
, E.UNIT_OF_MEASURE) UNIT_OF_MEASURE
, E.DOCUMENT_HEADER_ID
, E.DOCUMENT_DISTRIBUTION_ID
, E.DOCUMENT_LINE_NUMBER
, E.DOCUMENT_PAYMENT_ID
, E.DOCUMENT_TYPE
, E.DOCUMENT_DISTRIBUTION_TYPE
, E.VENDOR_ID
FROM PA_LOOKUPS L
, PA_EXPENDITURE_TYPES ET
, PA_EXPENDITURES X
, HR_ORG_UNITS_NO_JOIN O
, HR_ALL_ORGANIZATION_UNITS_TL OTL
, PA_TASKS T
, PA_PROJECTS_ALL P
, PA_EXPENDITURE_COMMENTS C
, PA_TRANSACTION_SOURCES TR
, PA_EXPENDITURE_ITEMS E
WHERE T.PROJECT_ID = P.PROJECT_ID
AND E.TASK_ID = T.TASK_ID
AND E.ORGANIZATION_ID = O.ORGANIZATION_ID (+)
AND O.ORGANIZATION_ID = OTL.ORGANIZATION_ID(+)
AND DECODE(OTL.ORGANIZATION_ID
, NULL
, '1'
, OTL.LANGUAGE) = DECODE(OTL.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND E.EXPENDITURE_ID = X.EXPENDITURE_ID
AND E.EXPENDITURE_TYPE = ET.EXPENDITURE_TYPE
AND E.EXPENDITURE_ITEM_ID = C.EXPENDITURE_ITEM_ID (+)
AND E.TRANSACTION_SOURCE = TR.TRANSACTION_SOURCE (+)
AND DECODE(E.UNIT_OF_MEASURE
, NULL
, ET.UNIT_OF_MEASURE
, E.UNIT_OF_MEASURE) = L.LOOKUP_CODE
AND L.LOOKUP_TYPE = 'UNIT'