DBA Data[Home] [Help]

APPS.CZ_OM_ATP_CALLBACK dependencies on BOM_EXPLOSIONS

Line 33: TYPE uom_tbl_type IS TABLE OF bom_explosions.PRIMARY_UOM_CODE%TYPE INDEX BY PLS_INTEGER;

29:
30: extend_atp_rec_exc EXCEPTION;
31:
32: TYPE num_tbl_type IS TABLE OF NUMBER INDEX BY PLS_INTEGER;
33: TYPE uom_tbl_type IS TABLE OF bom_explosions.PRIMARY_UOM_CODE%TYPE INDEX BY PLS_INTEGER;
34:
35: --------------------------------------------------------------------------------
36: -- based on oe_order_sch_util (not a public procedure)
37: -- having code here gives us more control anyway, some fields were added

Line 296: FROM bom_explosions

292: -- Note bom explosion with included mode only contains mc std items
293: -- otherwise we would need to check bom_item_type = 4
294: SELECT component_item_id, extended_quantity, primary_uom_code
295: BULK COLLECT INTO l_itm_tbl, l_qty_tbl, l_uom_tbl
296: FROM bom_explosions
297: WHERE explosion_type = EXPLODE_TYPE_INCLUDED
298: AND plan_level > 0
299: AND extended_quantity > 0
300: AND TOP_BILL_SEQUENCE_ID =