Product: | PA - Projects |
---|---|
Description: | View of individual burden cost components, along with the labor multiplier, of the bill amount. |
Implementation/DBA Data: | APPS.PA_INV_BURDEN_DETAILS_LM_V |
SELECT IBDV.PROJECT_NUMBER
, IBDV.PROJECT_NAME
, IBDV.PROJECT_ID
, IBDV.DRAFT_INVOICE_NUM
, IBDV.RA_INVOICE_NUMBER
, IBDV.BILL_THROUGH_DATE
, IBDV.RELEASED_DATE
, IBDV.INVOICE_DATE
, IBDV.GL_DATE
, IBDV.DRAFT_INVOICE_ITEM_LINE_NUM
, IBDV.EXPENDITURE_ITEM_ID
, IBDV.RDL_LINE_NUM
, IBDV.TASK_NUMBER
, IBDV.TASK_NAME
, IBDV.TASK_ID
, IBDV.EXPENDITURE_ORGANIZATION
, IBDV.EXPENDITURE_ORGANIZATION_ID
, IBDV.EXPENDITURE_TYPE
, IBDV.EXPENDITURE_ITEM_DATE
, IBDV.RAW_COST
, IBDV.PROJECT_CURRENCY_CODE
, IBDV.BILL_AMOUNT
, IBDV.BURDEN_COST
, IBDV.COST_BASE
, IBDV.CB_SORT_ORDER
, IBDV.BURDEN_COST_CODE
, IBDV.BCC_PRECEDENCE
, IBDV.INPUT_MULTIPLIER
, IBDV.COMPILED_MULTIPLIER
, IBDV.BURDEN_SCHEDULE
, IBDV.BURDEN_SCHEDULE_ID
, IBDV.BURDEN_SCHEDULE_REVISION
, IBDV.BURDEN_SCHEDULE_REVISION_ID
, IBDV.BURDEN_STRUCTURE
, IBDV.COMPILED_SET_ID
FROM PA_INV_BURDEN_DETAILS_V IBDV UNION ALL SELECT IBDV.PROJECT_NUMBER
, IBDV.PROJECT_NAME
, IBDV.PROJECT_ID
, IBDV.DRAFT_INVOICE_NUM
, IBDV.RA_INVOICE_NUMBER
, IBDV.BILL_THROUGH_DATE
, IBDV.RELEASED_DATE
, IBDV.INVOICE_DATE
, IBDV.GL_DATE
, IBDV.DRAFT_INVOICE_ITEM_LINE_NUM
, IBDV.EXPENDITURE_ITEM_ID
, IBDV.RDL_LINE_NUM
, IBDV.TASK_NUMBER
, IBDV.TASK_NAME
, IBDV.TASK_ID
, IBDV.EXPENDITURE_ORGANIZATION
, IBDV.EXPENDITURE_ORGANIZATION_ID
, IBDV.EXPENDITURE_TYPE
, IBDV.EXPENDITURE_ITEM_DATE
, IBDV.RAW_COST
, IBDV.PROJECT_CURRENCY_CODE
, IBDV.BILL_AMOUNT
, IBDV.BILL_AMOUNT - (IBDV.RAW_COST * (1+SUM(IBDV.COMPILED_MULTIPLIER)))
, IBDV.COST_BASE
, IBDV.CB_SORT_ORDER
, SUBSTR(LMLUP.MEANING
, 1
, 30)
, MAX(IBDV.BCC_PRECEDENCE) + 1
, (IBDV.BILL_AMOUNT - (IBDV.RAW_COST * (1+ SUM(IBDV.COMPILED_MULTIPLIER)))) / (IBDV.RAW_COST * (1+SUM(IBDV.COMPILED_MULTIPLIER)))
, DECODE( (IBDV.BILL_AMOUNT - (IBDV.RAW_COST * (1+ SUM(IBDV.COMPILED_MULTIPLIER)))) / (IBDV.RAW_COST * (1+SUM(IBDV.COMPILED_MULTIPLIER)))
, 0
, 0
, (IBDV.BILL_AMOUNT - (IBDV.RAW_COST * (1+ SUM(IBDV.COMPILED_MULTIPLIER)))) / IBDV.RAW_COST)
, IBDV.BURDEN_SCHEDULE
, IBDV.BURDEN_SCHEDULE_ID
, IBDV.BURDEN_SCHEDULE_REVISION
, IBDV.BURDEN_SCHEDULE_REVISION_ID
, IBDV.BURDEN_STRUCTURE
, IBDV.COMPILED_SET_ID
FROM PA_INV_BURDEN_DETAILS_V IBDV
, PA_LOOKUPS LMLUP
WHERE LMLUP.LOOKUP_TYPE = 'TRANSLATION'
AND LMLUP.LOOKUP_CODE = 'LABOR MULTIPLIER BCC' GROUP BY IBDV.PROJECT_NUMBER
, IBDV.PROJECT_NAME
, IBDV.PROJECT_ID
, IBDV.DRAFT_INVOICE_NUM
, IBDV.RA_INVOICE_NUMBER
, IBDV.BILL_THROUGH_DATE
, IBDV.RELEASED_DATE
, IBDV.INVOICE_DATE
, IBDV.GL_DATE
, IBDV.DRAFT_INVOICE_ITEM_LINE_NUM
, IBDV.EXPENDITURE_ITEM_ID
, IBDV.RDL_LINE_NUM
, IBDV.TASK_NUMBER
, IBDV.TASK_NAME
, IBDV.TASK_ID
, IBDV.EXPENDITURE_ORGANIZATION
, IBDV.EXPENDITURE_ORGANIZATION_ID
, IBDV.EXPENDITURE_TYPE
, IBDV.EXPENDITURE_ITEM_DATE
, IBDV.RAW_COST
, IBDV.PROJECT_CURRENCY_CODE
, IBDV.BILL_AMOUNT
, IBDV.COST_BASE
, IBDV.CB_SORT_ORDER
, SUBSTR(LMLUP.MEANING
, 1
, 30)
, IBDV.BURDEN_SCHEDULE
, IBDV.BURDEN_SCHEDULE_ID
, IBDV.BURDEN_SCHEDULE_REVISION
, IBDV.BURDEN_SCHEDULE_REVISION_ID
, IBDV.BURDEN_STRUCTURE
, IBDV.COMPILED_SET_ID HAVING IBDV.BILL_AMOUNT != (IBDV.RAW_COST * (1+SUM(IBDV.COMPILED_MULTIPLIER)))