DBA Data[Home] [Help]

APPS.BOM_COMPONENT_API dependencies on MTL_SECONDARY_LOCATORS

Line 3114: mtl_secondary_locators item

3110: BEGIN
3111: SELECT 'restricted loc exists'
3112: INTO dummy
3113: FROM mtl_item_locations loc,
3114: mtl_secondary_locators item
3115: WHERE loc.inventory_location_id = c3rec.SLI
3116: AND loc.organization_id = c3rec.OI
3117: AND loc.subinventory_code = c3rec.SS
3118: AND nvl(loc.disable_date,trunc(c3rec.EDD)+1) >

Line 3171: mtl_secondary_locators item

3167: BEGIN
3168: SELECT 'restricted loc exists'
3169: INTO dummy
3170: FROM mtl_item_locations loc,
3171: mtl_secondary_locators item
3172: WHERE loc.inventory_location_id = c3rec.SLI
3173: AND loc.organization_id = c3rec.OI
3174: AND loc.subinventory_code = c3rec.SS
3175: AND nvl(loc.disable_date,trunc(c3rec.EDD)+1) >

Line 3232: mtl_secondary_locators item

3228: BEGIN
3229: SELECT 'restricted loc exists'
3230: INTO dummy
3231: FROM mtl_item_locations loc,
3232: mtl_secondary_locators item
3233: WHERE loc.inventory_location_id = c3rec.SLI
3234: AND loc.organization_id = c3rec.OI
3235: AND loc.subinventory_code = c3rec.SS
3236: AND nvl(loc.disable_date,trunc(c3rec.EDD)+1) >

Line 4303: mtl_secondary_locators item

4299: BEGIN
4300: SELECT 'restricted loc exists'
4301: INTO dummy
4302: FROM mtl_item_locations loc,
4303: mtl_secondary_locators item
4304: WHERE loc.inventory_location_id = c1rec.SLI
4305: AND loc.organization_id = c1rec.OI
4306: AND loc.subinventory_code = c1rec.SS
4307: AND nvl(loc.disable_date,trunc(c1rec.EDD)+1) >

Line 4359: mtl_secondary_locators item

4355: BEGIN
4356: SELECT 'restricted loc exists'
4357: INTO dummy
4358: FROM mtl_item_locations loc,
4359: mtl_secondary_locators item
4360: WHERE loc.inventory_location_id = c1rec.SLI
4361: AND loc.organization_id = c1rec.OI
4362: AND loc.subinventory_code = c1rec.SS
4363: AND nvl(loc.disable_date,trunc(c1rec.EDD)+1) >

Line 4419: mtl_secondary_locators item

4415: BEGIN
4416: SELECT 'restricted loc exists'
4417: INTO dummy
4418: FROM mtl_item_locations loc,
4419: mtl_secondary_locators item
4420: WHERE loc.inventory_location_id = c1rec.SLI
4421: AND loc.organization_id = c1rec.OI
4422: AND loc.subinventory_code = c1rec.SS
4423: AND nvl(loc.disable_date,trunc(c1rec.EDD)+1) >