Product: | PA - Projects |
---|---|
Description: | This user customizable view defines the summarization criteria for burden summarization of commitment transactions. |
Implementation/DBA Data: | APPS.PA_CMT_BURDEN_SUMMARY_V |
SELECT PROJECT_ID SOURCE_PROJECT_ID
, TASK_ID SOURCE_TASK_ID
, ORGANIZATION_ID SOURCE_ORG_ID
, PA_PERIOD SOURCE_PA_PERIOD
, GL_PERIOD SOURCE_GL_PERIOD
, TRANSACTION_SOURCE SOURCE_TXN_SOURCE
, LINE_TYPE SOURCE_LINE_TYPE
, IND_COST_CODE SOURCE_IND_COST_CODE
, ORIGINAL_TXN_REFERENCE1 SOURCE_TXN_REF1
, ORIGINAL_TXN_REFERENCE2 SOURCE_TXN_REF2
, ORIGINAL_TXN_REFERENCE3 SOURCE_TXN_REF3
, CMT_EXPENDITURE_TYPE SOURCE_EXPENDITURE_TYPE
, ICC_EXPENDITURE_TYPE SOURCE_IND_EXPENDITURE_TYPE
, EXPENDITURE_CATEGORY SOURCE_EXP_CATEGORY
, REVENUE_CATEGORY_CODE SOURCE_REVENUE_CATEGORY
, COST_BASE SOURCE_COST_BASE
, COMPILED_MULTIPLIER SOURCE_COMPILED_MULTIPLIER
, IND_RATE_SCH_ID SOURCE_IND_RATE_SCH_ID
, IND_RATE_SCH_REVISION_ID SOURCE_IND_RATE_SCH_REV_ID
, BURDEN_COST SOURCE_BURDEN_COST
, BURDEN_SUM_SOURCE_RUN_ID SOURCE_RUN_ID
, BURDEN_SUM_REJECTION_CODE SOURCE_BURDEN_SUM_REJ_CODE
, RESOURCE_CLASS RESOURCE_CLASS
, SYSTEM_LINKAGE_FUNCTION SOURCE_SYSTEM_LINKAGE_FUNCTION
, PROJECT_ID DEST_PROJECT_ID
, TASK_ID DEST_TASK_ID
, ORGANIZATION_ID DEST_ORG_ID
, ICC_EXPENDITURE_TYPE DEST_IND_EXP_TYPE
, ORIGINAL_TXN_REFERENCE1 DEST_TXN_REF1
, PA_PERIOD DEST_PA_PERIOD
, GL_PERIOD DEST_GL_PERIOD
, TRANSACTION_SOURCE DEST_TXN_SOURCE
, EXPENDITURE_CATEGORY DEST_EXP_CATEGORY
, REVENUE_CATEGORY_CODE DEST_REVENUE_CATEGORY
, LINE_TYPE DEST_LINE_TYPE
, IND_COST_CODE DEST_IND_COST_CODE
, ACCT_RAW_COST
, ACCT_BURDENED_COST
, DENOM_CURRENCY_CODE
, DENOM_RAW_COST
, DENOM_BURDENED_COST
, ACCT_CURRENCY_CODE
, ACCT_RATE_DATE
, ACCT_RATE_TYPE
, ACCT_EXCHANGE_RATE
, PROJECT_CURRENCY_CODE
, PROJECT_RATE_DATE
, PROJECT_RATE_TYPE
, PROJECT_EXCHANGE_RATE
, VENDOR_ID
, INVENTORY_ITEM_ID
, BOM_LABOR_RESOURCE_ID
, BOM_EQUIPMENT_RESOURCE_ID
, NVL(DENOM_CURRENCY_CODE
, ACCT_CURRENCY_CODE) || ACCT_CURRENCY_CODE || PROJECT_CURRENCY_CODE || PROJECT_ID ||TASK_ID|| ORGANIZATION_ID||GL_PERIOD || PA_PERIOD || TRANSACTION_SOURCE || LINE_TYPE ||IND_COST_CODE || RESOURCE_CLASS ||SYSTEM_LINKAGE_FUNCTION || PA_CLIENT_EXTN_BURDEN_RESOURCE.CLIENT_GROUPING ( NULL
, NULL
, NULL
, NULL
, NULL
, PA_CMT_BURDEN_DETAIL_V.INVENTORY_ITEM_ID
, PA_CMT_BURDEN_DETAIL_V.VENDOR_ID
, PA_CMT_BURDEN_DETAIL_V.BOM_LABOR_RESOURCE_ID
, PA_CMT_BURDEN_DETAIL_V.BOM_EQUIPMENT_RESOURCE_ID ) DEST_SUMMARY_GROUP
FROM PA_CMT_BURDEN_DETAIL_V