DBA Data[Home] [Help]

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