View: PA_EXPND_ITEMS_REVIEW_V

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

View Text

SELECT EI.ROWID ROW_ID
, EI.EXPENDITURE_ID EXPENDITURE_ID
, EI.EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID
, EI.EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, EI.EXPENDITURE_TYPE EXPENDITURE_TYPE
, EI.QUANTITY QUANTITY
, NVL(EI.RAW_COST
, PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT( PA_UTILS.GETEXPTYPECOSTRATE(EI.EXPENDITURE_TYPE
, EI.EXPENDITURE_ITEM_DATE) * NVL(EI.QUANTITY
, 0)
, EI.PROJECT_CURRENCY_CODE)) AMOUNT
, EI.BILLABLE_FLAG BILLABLE_FLAG
, EI.ACCRUAL_RATE ACCRUAL_RATE
, EI.ACCRUED_REVENUE ACCRUED_REVENUE
, EI.ADJUSTED_EXPENDITURE_ITEM_ID ADJUSTED_EXPENDITURE_ITEM_ID
, EI.ADJUSTED_RATE ADJUSTED_RATE
, EI.ADJUSTED_REVENUE ADJUSTED_REVENUE
, EI.ATTRIBUTE1 ATTRIBUTE1
, EI.ATTRIBUTE10 ATTRIBUTE10
, EI.ATTRIBUTE2 ATTRIBUTE2
, EI.ATTRIBUTE3 ATTRIBUTE3
, EI.ATTRIBUTE4 ATTRIBUTE4
, EI.ATTRIBUTE5 ATTRIBUTE5
, EI.ATTRIBUTE6 ATTRIBUTE6
, EI.ATTRIBUTE7 ATTRIBUTE7
, EI.ATTRIBUTE8 ATTRIBUTE8
, EI.ATTRIBUTE9 ATTRIBUTE9
, EI.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, EI.BILL_AMOUNT BILL_AMOUNT
, EI.BILL_EMPLOYEE_BILLING_TITLE BILL_EMPLOYEE_BILLING_TITLE
, EI.BILL_HOLD_FLAG BILL_HOLD_FLAG
, EI.BILL_JOB_BILLING_TITLE BILL_JOB_BILLING_TITLE
, EI.BILL_JOB_ID BILL_JOB_ID
, EI.BILL_RATE BILL_RATE
, EI.BILL_RATE_MULTIPLIER BILL_RATE_MULTIPLIER
, EI.BURDEN_COST BURDEN_COST
, EI.BURDEN_COST_RATE BURDEN_COST_RATE
, EI.CONVERTED_FLAG CONVERTED_FLAG
, EI.COST_BURDEN_DISTRIBUTED_FLAG COST_BURDEN_DISTRIBUTED_FLAG
, EI.COST_DISTRIBUTED_FLAG COST_DISTRIBUTED_FLAG
, EI.COST_DIST_REJECTION_CODE COST_DIST_REJECTION_CODE
, EI.COST_IND_COMPILED_SET_ID COST_IND_COMPILED_SET_ID
, EI.CREATED_BY CREATED_BY
, EI.CREATION_DATE CREATION_DATE
, EI.EVENT_NUM EVENT_NUM
, EI.EVENT_TASK_ID EVENT_TASK_ID
, EI.FORECAST_REVENUE FORECAST_REVENUE
, EI.IND_COST_DIST_REJECTION_CODE IND_COST_DIST_REJECTION_CODE
, EI.INV_IND_COMPILED_SET_ID INV_IND_COMPILED_SET_ID
, EI.JOB_ID JOB_ID
, EI.LABOR_COST_MULTIPLIER_NAME LABOR_COST_MULTIPLIER_NAME
, EI.LAST_UPDATED_BY LAST_UPDATED_BY
, EI.LAST_UPDATE_DATE LAST_UPDATE_DATE
, EI.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, EI.NET_ZERO_ADJUSTMENT_FLAG NET_ZERO_ADJUSTMENT_FLAG
, EI.NON_LABOR_RESOURCE NON_LABOR_RESOURCE
, EI.ORGANIZATION_ID ORGANIZATION_ID
, EI.ORIG_TRANSACTION_REFERENCE ORIG_TRANSACTION_REFERENCE
, EI.OVERRIDE_TO_ORGANIZATION_ID OVERRIDE_TO_ORGANIZATION_ID
, EI.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, EI.PROGRAM_ID PROGRAM_ID
, EI.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, EI.PROJECT_ID PROJECT_ID
, NVL(EI.RAW_COST_RATE
, PA_UTILS.GETEXPTYPECOSTRATE(EI.EXPENDITURE_TYPE
, EI.EXPENDITURE_ITEM_DATE)) RAW_COST_RATE
, EI.RAW_REVENUE RAW_REVENUE
, EI.REQUEST_ID REQUEST_ID
, EI.REVENUE_DISTRIBUTED_FLAG REVENUE_DISTRIBUTED_FLAG
, EI.REV_DIST_REJECTION_CODE REV_DIST_REJECTION_CODE
, EI.REV_IND_COMPILED_SET_ID REV_IND_COMPILED_SET_ID
, EI.SOURCE_EXPENDITURE_ITEM_ID SOURCE_EXPENDITURE_ITEM_ID
, EI.TASK_ID TASK_ID
, EI.TRANSACTION_SOURCE TRANSACTION_SOURCE
, EI.TRANSFERRED_FROM_EXP_ITEM_ID TRANSFERRED_FROM_EXP_ITEM_ID
, PR.NAME PROJECT_NAME
, PR.SEGMENT1 PROJECT_NUMBER
, PT.TASK_NUMBER TASK_NUMBER
, PT.TASK_NAME TASK_NAME
, LK.MEANING UOM
, TO_CHAR(EI.EXPENDITURE_ITEM_DATE
, 'DAY') WEEK_DAY
, EI.SYSTEM_LINKAGE_FUNCTION SYSTEM_LINKAGE_FUNCTION
, EC1.EXPENDITURE_COMMENT EXPENDITURE_COMMENT
, EI.RECEIPT_CURRENCY_AMOUNT
, EI.RECEIPT_CURRENCY_CODE
, 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_DATE
, EI.ACCT_RATE_TYPE
, EI.ACCT_EXCHANGE_RATE
, EI.ACCT_RAW_COST
, EI.ACCT_BURDENED_COST
, EI.PROJECT_CURRENCY_CODE
, EI.PROJECT_RATE_DATE
, EI.PROJECT_RATE_TYPE
, EI.PROJECT_EXCHANGE_RATE
, EI.ORG_ID
FROM PA_EXPENDITURE_COMMENTS EC1
, PA_PROJECTS_ALL PR
, PA_TASKS PT
, PA_LOOKUPS LK
, PA_EXPENDITURE_TYPES ET
, PA_EXPENDITURE_ITEMS EI
WHERE PR.PROJECT_ID = PT.PROJECT_ID
AND EI.TASK_ID = PT.TASK_ID
AND EC1.EXPENDITURE_ITEM_ID (+) = EI.EXPENDITURE_ITEM_ID
AND LK.LOOKUP_TYPE = 'UNIT'
AND NVL(EI.UNIT_OF_MEASURE
, ET.UNIT_OF_MEASURE) = LK.LOOKUP_CODE
AND EI.EXPENDITURE_TYPE = ET.EXPENDITURE_TYPE

Columns