APPS.WSMPLOAD dependencies on BOM_INVENTORY_COMPONENTS
Line 286: from bom_inventory_components
282:
283: -- OPTII-PERF: Find if phantom exists or not.
284: BEGIN
285: select 1 into l_phantom_exists 286: from bom_inventory_components 287: where bill_sequence_id = c_algorithm_rec.common_bom_sequence_id
288: and c_algorithm_rec.bom_revision_date between effectivity_date and
289: nvl(disable_date,c_algorithm_rec.bom_revision_date+1)
290: and wip_supply_type = 6