[Home] [Help]
285: SELECT 'Planning Bill'
286: INTO l_dummy
287: FROM sys.dual
288: WHERE EXISTS (SELECT 'Planning Item'
289: FROM bom_bill_of_materials bom,
290: mtl_system_items msi,
291: bom_inventory_components bic
292: WHERE msi.bom_item_type = 3 /* PLANNING */
293: AND msi.inventory_item_id = bom.assembly_item_id