APPS.BOMPVALR dependencies on MTL_ITEM_LOCATIONS

Line 506: from mtl_item_locations

502: if (r_loc = 2) then /* non-restricted locator */
503: begin
504: select 'loc exists'
505: into dummy
506: from mtl_item_locations
507: where inventory_location_id = c1rec.CLI
508: and organization_id = c1rec.OI
509: and subinventory_code = c1rec.CS
510: and nvl(disable_date,trunc(SYSDATE)+1) > trunc(SYSDATE);

Line 519: from mtl_item_locations loc,

515: else /* restricted locator */
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

Line 557: from mtl_item_locations

553: if (r_loc = 2) then /* non-restricted locator */
554: begin
555: select 'loc exists'
556: into dummy
557: from mtl_item_locations
558: where inventory_location_id = c1rec.CLI
559: and organization_id = c1rec.OI
560: and subinventory_code = c1rec.CS
561: and nvl(disable_date,trunc(SYSDATE)+1) >

Line 571: from mtl_item_locations loc,

567: else /* restricted locator */
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

Line 611: from mtl_item_locations

607: if (r_loc = 2) then /* non-restricted locator */
608: begin
609: select 'loc exists'
610: into dummy
611: from mtl_item_locations
612: where inventory_location_id = c1rec.CLI
613: and organization_id = c1rec.OI
614: and subinventory_code = c1rec.CS
615: and nvl(disable_date,trunc(SYSDATE)+1) >

Line 625: from mtl_item_locations loc,

621: else /* restricted locator */
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