View: PA_EXPENDITURE_ITEMS_V

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

View Text

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'

Columns