DBA Data[Home] [Help]

APPS.BOM_CSTROMMA_XMLP_PKG dependencies on CST_COST_TYPES

Line 116: CST_COST_TYPES

112: COST_TYPE,
113: DEFAULT_COST_TYPE_ID
114: INTO P_COST_TYPE,P_DEF_COST_TYPE
115: FROM
116: CST_COST_TYPES
117: WHERE COST_TYPE_ID = P_COST_TYPE_ID;
118: P_SQL_SELECT_COST_TYPE := ' NVL( temp.ship_quantity, 0 ) * ' || ' NVL( decode( cic1.cost_type_id, null, cic2.item_cost, cic1.item_cost ), 0 ) ';
119: P_SQL_FROM_COST_TYPE := ', cst_item_costs cic1, cst_item_costs cic2';
120: P_SQL_WHERE_COST_TYPE := ' cic1.cost_type_id(+) = ' || P_COST_TYPE_ID || ' and ' || ' cic1.inventory_item_id(+) = temp.inventory_item_id and '