DBA Data[Home] [Help]

APPS.CSTPPWMT dependencies on CST_PAC_REQ_OPER_COST_DETAILS

Line 742: MERGE INTO CST_PAC_REQ_OPER_COST_DETAILS cprocd

738: /* R12 PAC Enhancement: Populate CPROCD only for Use BOM based Material Algo */
739: IF (p_material_relief_algorithm = 0) THEN
740: -- BOM Based algo
741: l_stmt_num := 40;
742: MERGE INTO CST_PAC_REQ_OPER_COST_DETAILS cprocd
743: USING (SELECT sum(NVL(cpicd.ITEM_COST,0) * -1 * p_pri_qty) cost,
744: (-1 * p_pri_qty) qty,
745: cpicd.cost_element_id cost_element_id
746: FROM CST_PAC_ITEM_COSTS cpic,