DBA Data[Home] [Help]

APPS.BOMPVALR dependencies on MTL_SECONDARY_LOCATORS

Line 520: mtl_secondary_locators item

516: begin
517: select 'restricted loc exists'
518: into dummy
519: from mtl_item_locations loc,
520: mtl_secondary_locators item
521: where loc.inventory_location_id = c1rec.CLI
522: and loc.organization_id = c1rec.OI
523: and loc.subinventory_code = c1rec.CS
524: and nvl(loc.disable_date,trunc(SYSDATE)+1) >

Line 572: mtl_secondary_locators item

568: begin
569: select 'restricted loc exists'
570: into dummy
571: from mtl_item_locations loc,
572: mtl_secondary_locators item
573: where loc.inventory_location_id = c1rec.CLI
574: and loc.organization_id = c1rec.OI
575: and loc.subinventory_code = c1rec.CS
576: and nvl(loc.disable_date,trunc(SYSDATE)+1) >

Line 626: mtl_secondary_locators item

622: begin
623: select 'restricted loc exists'
624: into dummy
625: from mtl_item_locations loc,
626: mtl_secondary_locators item
627: where loc.inventory_location_id = c1rec.CLI
628: and loc.organization_id = c1rec.OI
629: and loc.subinventory_code = c1rec.CS
630: and nvl(loc.disable_date,trunc(SYSDATE)+1) >