VIEW: APPS.PA_EXPENDITURE_ITEMS_ALL_MRC_V

Source

View Text - Preformatted

SELECT mc.ROWID , mc.EXPENDITURE_ITEM_ID , pa1.RAW_COST , pa1.RAW_COST_RATE , pa1.BURDEN_COST , pa1.BURDEN_COST_RATE , mc.RAW_REVENUE , mc.BILL_RATE , mc.ACCRUED_REVENUE , mc.ACCRUAL_RATE , mc.ADJUSTED_REVENUE , mc.ADJUSTED_RATE , pa1.BILL_AMOUNT , mc.BILL_AMOUNT , pa1.BILL_TRANS_BILL_AMOUNT , pa1.PROJECT_BILL_AMOUNT , mc.FORECAST_REVENUE , pa1.LAST_UPDATE_DATE, pa1.LAST_UPDATED_BY, pa1.CREATION_DATE, pa1.CREATED_BY, pa1.EXPENDITURE_ID, pa1.TASK_ID, pa1.EXPENDITURE_ITEM_DATE, pa1.EXPENDITURE_TYPE, pa1.COST_DISTRIBUTED_FLAG, pa1.REVENUE_DISTRIBUTED_FLAG, pa1.BILLABLE_FLAG, pa1.BILL_HOLD_FLAG, pa1.QUANTITY, pa1.UNIT_OF_MEASURE , pa1.NON_LABOR_RESOURCE, pa1.ORGANIZATION_ID, pa1.JOB_ID, pa1.OVERRIDE_TO_ORGANIZATION_ID, pa1.COST_DIST_REJECTION_CODE, pa1.LABOR_COST_MULTIPLIER_NAME, pa1.BILL_RATE_MULTIPLIER, pa1.REV_DIST_REJECTION_CODE, pa1.EVENT_NUM, pa1.EVENT_TASK_ID, pa1.BILL_JOB_ID, pa1.BILL_JOB_BILLING_TITLE, pa1.BILL_EMPLOYEE_BILLING_TITLE, pa1.ADJUSTED_EXPENDITURE_ITEM_ID, pa1.NET_ZERO_ADJUSTMENT_FLAG, pa1.TRANSFERRED_FROM_EXP_ITEM_ID, pa1.CONVERTED_FLAG, pa1.LAST_UPDATE_LOGIN, pa1.REQUEST_ID, pa1.PROGRAM_APPLICATION_ID, pa1.PROGRAM_ID, pa1.PROGRAM_UPDATE_DATE, pa1.ATTRIBUTE_CATEGORY, pa1.ATTRIBUTE1, pa1.ATTRIBUTE2, pa1.ATTRIBUTE3, pa1.ATTRIBUTE4, pa1.ATTRIBUTE5, pa1.ATTRIBUTE6, pa1.ATTRIBUTE7, pa1.ATTRIBUTE8, pa1.ATTRIBUTE9, pa1.ATTRIBUTE10, pa1.COST_IND_COMPILED_SET_ID, pa1.REV_IND_COMPILED_SET_ID, pa1.INV_IND_COMPILED_SET_ID, pa1.COST_BURDEN_DISTRIBUTED_FLAG, pa1.IND_COST_DIST_REJECTION_CODE, pa1.ORIG_TRANSACTION_REFERENCE, pa1.TRANSACTION_SOURCE, pa1.PROJECT_ID, pa1.SOURCE_EXPENDITURE_ITEM_ID, pa1.ORG_ID, pa1.SYSTEM_LINKAGE_FUNCTION, pa1.BURDEN_SUM_DEST_RUN_ID, pa1.RECEIPT_CURRENCY_AMOUNT, pa1.RECEIPT_CURRENCY_CODE, pa1.RECEIPT_EXCHANGE_RATE, pa1.DENOM_CURRENCY_CODE, pa1.DENOM_RAW_COST, pa1.DENOM_BURDENED_COST, pa1.ACCT_EXCHANGE_ROUNDING_LIMIT, mc.CURRENCY_CODE, mc.COST_CONVERSION_DATE, mc.COST_RATE_TYPE, mc.COST_EXCHANGE_RATE, mc.RAW_COST, mc.BURDEN_COST, pa1.PROJECT_CURRENCY_CODE, pa1.PROJECT_RATE_DATE, pa1.PROJECT_RATE_TYPE, pa1.PROJECT_EXCHANGE_RATE, pa1.DENORM_ID, pa1.CC_PRVDR_ORGANIZATION_ID, pa1.CC_RECVR_ORGANIZATION_ID, pa1.RECVR_ORG_ID, pa1.CC_CROSS_CHARGE_CODE, pa1.CC_CROSS_CHARGE_TYPE, pa1.CC_REJECTION_CODE, pa1.CC_BL_DISTRIBUTED_CODE, pa1.CC_IC_PROCESSED_CODE, pa1.DENOM_TP_CURRENCY_CODE, pa1.DENOM_TRANSFER_PRICE, mc.TP_RATE_TYPE, mc.TP_CONVERSION_DATE, mc.TP_EXCHANGE_RATE, mc.TRANSFER_PRICE, pa1.PROJACCT_TRANSFER_PRICE, pa1.CC_MARKUP_BASE_CODE, pa1.TP_BASE_AMOUNT, pa1.TP_IND_COMPILED_SET_ID, pa1.TP_BILL_RATE, pa1.TP_BILL_MARKUP_PERCENTAGE, pa1.TP_SCHEDULE_LINE_PERCENTAGE, pa1.TP_RULE_PERCENTAGE, pa1.CC_PRVDR_COST_RECLASS_CODE, pa1.cost_job_id, pa1.tp_job_id, pa1.prov_proj_bill_job_id ,pa1.BILL_TRANS_FORECAST_CURR_CODE ,pa1.BILL_TRANS_FORECAST_REVENUE ,pa1.BILL_TRANS_CURRENCY_CODE ,pa1.BILL_TRANS_RAW_REVENUE ,pa1.BILL_TRANS_ADJUSTED_REVENUE ,pa1.REVPROC_CURRENCY_CODE ,pa1.REVPROC_RATE_TYPE ,pa1.REVPROC_RATE_DATE ,pa1.REVPROC_EXCHANGE_RATE ,pa1.INVPROC_CURRENCY_CODE ,pa1.INVPROC_RATE_TYPE ,pa1.INVPROC_RATE_DATE ,pa1.INVPROC_EXCHANGE_RATE ,pa1.DISCOUNT_PERCENTAGE ,pa1.INV_GEN_REJECTION_CODE ,pa1.PROJFUNC_CURRENCY_CODE ,mc.RAW_REVENUE ,pa1.PROJECT_RAW_REVENUE ,pa1.PROJFUNC_COST_RATE_TYPE ,pa1.PROJFUNC_COST_RATE_DATE ,pa1.PROJFUNC_COST_EXCHANGE_RATE ,pa1.PROJECT_RAW_COST ,pa1.PROJECT_BURDENED_COST ,pa1.ASSIGNMENT_ID ,pa1.WORK_TYPE_ID ,pa1.PROJECT_TP_RATE_DATE ,pa1.PROJECT_TP_RATE_TYPE ,pa1.PROJECT_TP_EXCHANGE_RATE ,pa1.PROJECT_TRANSFER_PRICE ,pa1.tp_amt_type_code ,pa1.PROJFUNC_TP_RATE_DATE ,pa1.PROJFUNC_TP_RATE_TYPE ,pa1.PROJFUNC_TP_EXCHANGE_RATE ,pa1.PROJFUNC_TRANSFER_PRICE ,pa1.project_rev_rate_type ,pa1.project_rev_rate_date ,pa1.project_rev_exchange_rate ,pa1.projfunc_rev_rate_type ,pa1.projfunc_rev_rate_date ,pa1.projfunc_rev_exchange_rate ,mc.projfunc_inv_rate_type ,mc.projfunc_inv_rate_date ,mc.projfunc_inv_exchange_rate ,pa1.project_inv_rate_type ,pa1.project_inv_rate_date ,pa1.project_inv_exchange_rate ,mc.projfunc_fcst_rate_type ,mc.projfunc_fcst_rate_date ,mc.projfunc_fcst_exchange_rate ,pa1.Prvdr_Accrual_Date ,pa1.Recvr_Accrual_Date ,pa1.rate_disc_reason_code ,pa1.capital_event_id ,pa1.posted_denom_burdened_cost ,pa1.posted_project_burdened_cost ,pa1.posted_projfunc_burdened_cost ,pa1.posted_acct_burdened_cost ,pa1.adjustment_type ,pa1.po_line_id ,pa1.po_price_type ,pa1.inventory_item_id ,pa1.WIP_RESOURCE_ID ,pa1.document_header_id ,pa1.document_distribution_id ,pa1.document_line_number ,pa1.document_payment_id ,pa1.document_type ,pa1.document_distribution_type ,pa1.vendor_id ,pa1.historical_flag FROM PA_EXPENDITURE_ITEMS_ALL pa1, PA_MC_EXP_ITEMS_ALL mc WHERE pa1.expenditure_item_id = mc.expenditure_item_id AND mc.prc_assignment_id = -99 AND mc.set_of_books_id = NVL( TO_NUMBER( SUBSTRB( USERENV('CLIENT_INFO'), 45,10) ), -99)

View Text - HTML Formatted

SELECT MC.ROWID
, MC.EXPENDITURE_ITEM_ID
, PA1.RAW_COST
, PA1.RAW_COST_RATE
, PA1.BURDEN_COST
, PA1.BURDEN_COST_RATE
, MC.RAW_REVENUE
, MC.BILL_RATE
, MC.ACCRUED_REVENUE
, MC.ACCRUAL_RATE
, MC.ADJUSTED_REVENUE
, MC.ADJUSTED_RATE
, PA1.BILL_AMOUNT
, MC.BILL_AMOUNT
, PA1.BILL_TRANS_BILL_AMOUNT
, PA1.PROJECT_BILL_AMOUNT
, MC.FORECAST_REVENUE
, PA1.LAST_UPDATE_DATE
, PA1.LAST_UPDATED_BY
, PA1.CREATION_DATE
, PA1.CREATED_BY
, PA1.EXPENDITURE_ID
, PA1.TASK_ID
, PA1.EXPENDITURE_ITEM_DATE
, PA1.EXPENDITURE_TYPE
, PA1.COST_DISTRIBUTED_FLAG
, PA1.REVENUE_DISTRIBUTED_FLAG
, PA1.BILLABLE_FLAG
, PA1.BILL_HOLD_FLAG
, PA1.QUANTITY
, PA1.UNIT_OF_MEASURE
, PA1.NON_LABOR_RESOURCE
, PA1.ORGANIZATION_ID
, PA1.JOB_ID
, PA1.OVERRIDE_TO_ORGANIZATION_ID
, PA1.COST_DIST_REJECTION_CODE
, PA1.LABOR_COST_MULTIPLIER_NAME
, PA1.BILL_RATE_MULTIPLIER
, PA1.REV_DIST_REJECTION_CODE
, PA1.EVENT_NUM
, PA1.EVENT_TASK_ID
, PA1.BILL_JOB_ID
, PA1.BILL_JOB_BILLING_TITLE
, PA1.BILL_EMPLOYEE_BILLING_TITLE
, PA1.ADJUSTED_EXPENDITURE_ITEM_ID
, PA1.NET_ZERO_ADJUSTMENT_FLAG
, PA1.TRANSFERRED_FROM_EXP_ITEM_ID
, PA1.CONVERTED_FLAG
, PA1.LAST_UPDATE_LOGIN
, PA1.REQUEST_ID
, PA1.PROGRAM_APPLICATION_ID
, PA1.PROGRAM_ID
, PA1.PROGRAM_UPDATE_DATE
, PA1.ATTRIBUTE_CATEGORY
, PA1.ATTRIBUTE1
, PA1.ATTRIBUTE2
, PA1.ATTRIBUTE3
, PA1.ATTRIBUTE4
, PA1.ATTRIBUTE5
, PA1.ATTRIBUTE6
, PA1.ATTRIBUTE7
, PA1.ATTRIBUTE8
, PA1.ATTRIBUTE9
, PA1.ATTRIBUTE10
, PA1.COST_IND_COMPILED_SET_ID
, PA1.REV_IND_COMPILED_SET_ID
, PA1.INV_IND_COMPILED_SET_ID
, PA1.COST_BURDEN_DISTRIBUTED_FLAG
, PA1.IND_COST_DIST_REJECTION_CODE
, PA1.ORIG_TRANSACTION_REFERENCE
, PA1.TRANSACTION_SOURCE
, PA1.PROJECT_ID
, PA1.SOURCE_EXPENDITURE_ITEM_ID
, PA1.ORG_ID
, PA1.SYSTEM_LINKAGE_FUNCTION
, PA1.BURDEN_SUM_DEST_RUN_ID
, PA1.RECEIPT_CURRENCY_AMOUNT
, PA1.RECEIPT_CURRENCY_CODE
, PA1.RECEIPT_EXCHANGE_RATE
, PA1.DENOM_CURRENCY_CODE
, PA1.DENOM_RAW_COST
, PA1.DENOM_BURDENED_COST
, PA1.ACCT_EXCHANGE_ROUNDING_LIMIT
, MC.CURRENCY_CODE
, MC.COST_CONVERSION_DATE
, MC.COST_RATE_TYPE
, MC.COST_EXCHANGE_RATE
, MC.RAW_COST
, MC.BURDEN_COST
, PA1.PROJECT_CURRENCY_CODE
, PA1.PROJECT_RATE_DATE
, PA1.PROJECT_RATE_TYPE
, PA1.PROJECT_EXCHANGE_RATE
, PA1.DENORM_ID
, PA1.CC_PRVDR_ORGANIZATION_ID
, PA1.CC_RECVR_ORGANIZATION_ID
, PA1.RECVR_ORG_ID
, PA1.CC_CROSS_CHARGE_CODE
, PA1.CC_CROSS_CHARGE_TYPE
, PA1.CC_REJECTION_CODE
, PA1.CC_BL_DISTRIBUTED_CODE
, PA1.CC_IC_PROCESSED_CODE
, PA1.DENOM_TP_CURRENCY_CODE
, PA1.DENOM_TRANSFER_PRICE
, MC.TP_RATE_TYPE
, MC.TP_CONVERSION_DATE
, MC.TP_EXCHANGE_RATE
, MC.TRANSFER_PRICE
, PA1.PROJACCT_TRANSFER_PRICE
, PA1.CC_MARKUP_BASE_CODE
, PA1.TP_BASE_AMOUNT
, PA1.TP_IND_COMPILED_SET_ID
, PA1.TP_BILL_RATE
, PA1.TP_BILL_MARKUP_PERCENTAGE
, PA1.TP_SCHEDULE_LINE_PERCENTAGE
, PA1.TP_RULE_PERCENTAGE
, PA1.CC_PRVDR_COST_RECLASS_CODE
, PA1.COST_JOB_ID
, PA1.TP_JOB_ID
, PA1.PROV_PROJ_BILL_JOB_ID
, PA1.BILL_TRANS_FORECAST_CURR_CODE
, PA1.BILL_TRANS_FORECAST_REVENUE
, PA1.BILL_TRANS_CURRENCY_CODE
, PA1.BILL_TRANS_RAW_REVENUE
, PA1.BILL_TRANS_ADJUSTED_REVENUE
, PA1.REVPROC_CURRENCY_CODE
, PA1.REVPROC_RATE_TYPE
, PA1.REVPROC_RATE_DATE
, PA1.REVPROC_EXCHANGE_RATE
, PA1.INVPROC_CURRENCY_CODE
, PA1.INVPROC_RATE_TYPE
, PA1.INVPROC_RATE_DATE
, PA1.INVPROC_EXCHANGE_RATE
, PA1.DISCOUNT_PERCENTAGE
, PA1.INV_GEN_REJECTION_CODE
, PA1.PROJFUNC_CURRENCY_CODE
, MC.RAW_REVENUE
, PA1.PROJECT_RAW_REVENUE
, PA1.PROJFUNC_COST_RATE_TYPE
, PA1.PROJFUNC_COST_RATE_DATE
, PA1.PROJFUNC_COST_EXCHANGE_RATE
, PA1.PROJECT_RAW_COST
, PA1.PROJECT_BURDENED_COST
, PA1.ASSIGNMENT_ID
, PA1.WORK_TYPE_ID
, PA1.PROJECT_TP_RATE_DATE
, PA1.PROJECT_TP_RATE_TYPE
, PA1.PROJECT_TP_EXCHANGE_RATE
, PA1.PROJECT_TRANSFER_PRICE
, PA1.TP_AMT_TYPE_CODE
, PA1.PROJFUNC_TP_RATE_DATE
, PA1.PROJFUNC_TP_RATE_TYPE
, PA1.PROJFUNC_TP_EXCHANGE_RATE
, PA1.PROJFUNC_TRANSFER_PRICE
, PA1.PROJECT_REV_RATE_TYPE
, PA1.PROJECT_REV_RATE_DATE
, PA1.PROJECT_REV_EXCHANGE_RATE
, PA1.PROJFUNC_REV_RATE_TYPE
, PA1.PROJFUNC_REV_RATE_DATE
, PA1.PROJFUNC_REV_EXCHANGE_RATE
, MC.PROJFUNC_INV_RATE_TYPE
, MC.PROJFUNC_INV_RATE_DATE
, MC.PROJFUNC_INV_EXCHANGE_RATE
, PA1.PROJECT_INV_RATE_TYPE
, PA1.PROJECT_INV_RATE_DATE
, PA1.PROJECT_INV_EXCHANGE_RATE
, MC.PROJFUNC_FCST_RATE_TYPE
, MC.PROJFUNC_FCST_RATE_DATE
, MC.PROJFUNC_FCST_EXCHANGE_RATE
, PA1.PRVDR_ACCRUAL_DATE
, PA1.RECVR_ACCRUAL_DATE
, PA1.RATE_DISC_REASON_CODE
, PA1.CAPITAL_EVENT_ID
, PA1.POSTED_DENOM_BURDENED_COST
, PA1.POSTED_PROJECT_BURDENED_COST
, PA1.POSTED_PROJFUNC_BURDENED_COST
, PA1.POSTED_ACCT_BURDENED_COST
, PA1.ADJUSTMENT_TYPE
, PA1.PO_LINE_ID
, PA1.PO_PRICE_TYPE
, PA1.INVENTORY_ITEM_ID
, PA1.WIP_RESOURCE_ID
, PA1.DOCUMENT_HEADER_ID
, PA1.DOCUMENT_DISTRIBUTION_ID
, PA1.DOCUMENT_LINE_NUMBER
, PA1.DOCUMENT_PAYMENT_ID
, PA1.DOCUMENT_TYPE
, PA1.DOCUMENT_DISTRIBUTION_TYPE
, PA1.VENDOR_ID
, PA1.HISTORICAL_FLAG
FROM PA_EXPENDITURE_ITEMS_ALL PA1
, PA_MC_EXP_ITEMS_ALL MC
WHERE PA1.EXPENDITURE_ITEM_ID = MC.EXPENDITURE_ITEM_ID
AND MC.PRC_ASSIGNMENT_ID = -99
AND MC.SET_OF_BOOKS_ID = NVL( TO_NUMBER( SUBSTRB( USERENV('CLIENT_INFO')
, 45
, 10) )
, -99)