VIEW: APPS.PA_EXPND_ITEMS_REVIEW_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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