[Home] [Help]
432: GREATEST(0,(POD.QUANTITY_ORDERED-NVL(POD.QUANTITY_CANCELLED,0)
433: -NVL(POD.QUANTITY_BILLED,0))) * ((PLL.PRICE_OVERRIDE) +
434: (NVL(POD.NONRECOVERABLE_TAX,0) / POD.QUANTITY_ORDERED)) */
435: and NVL(CMT.denom_burdened_cost,0) =
436: NVL(PA_BURDEN_CMTS.get_cmt_burdened_cost(
437: NULL
438: , 'CMT'
439: , T.task_id
440: , POD.expenditure_item_date
533: and CMT.revenue_category = ET.revenue_category_code
534: and NVL(CMT.denom_raw_cost,0) = NVL(D.amount,0)
535: and NVL(CMT.tot_cmt_quantity,0) = NVL(D.pa_quantity,0)
536: and NVL(CMT.denom_burdened_cost,0) =
537: NVL(PA_BURDEN_CMTS.get_cmt_burdened_cost(
538: NULL
539: , 'CMT'
540: , T.task_id
541: , D.expenditure_item_date
631: and CMT.revenue_category = ET.revenue_category_code
632: and CMT.acct_raw_cost = (RD.REQ_LINE_QUANTITY * RL.UNIT_PRICE) + NVL(RD.NONRECOVERABLE_TAX,0)
633: and CMT.tot_cmt_quantity = RD.req_line_quantity
634: and NVL(CMT.acct_burdened_cost,0) =
635: NVL(PA_BURDEN_CMTS.get_cmt_burdened_cost(
636: NULL
637: , 'CMT'
638: , T.task_id
639: , RD.expenditure_item_date
982: AND CMT.revenue_category = PJREQ.revenue_category
983: AND CMT.acct_raw_cost = PJREQ.amount
984: AND CMT.tot_cmt_quantity = PJREQ.quantity
985: AND NVL(CMT.acct_burdened_cost,0) =
986: NVL(PA_BURDEN_CMTS.get_cmt_burdened_cost(
987: NULL
988: , 'CMT'
989: , PJREQ.task_id
990: , PJREQ.expenditure_item_date
1240: PJPO.task_id,
1241: POD.code_combination_id,0,NULL,NULL, NULL, NULL, nvl(g.sla_ledger_cash_basis_flag,'N')))) * /*Bug#4905552*/
1242: ((PLL.PRICE_OVERRIDE) +(NVL(POD.NONRECOVERABLE_TAX,0) / PJPO.QUANTITY_ORDERED))
1243: AND NVL(CMT.denom_burdened_cost,0) =
1244: NVL(PA_BURDEN_CMTS.get_cmt_burdened_cost(
1245: NULL
1246: , 'CMT'
1247: , PJPO.task_id
1248: , PJPO.expenditure_item_date