APPS.BOM_COMPONENT_API dependencies on MTL_ITEM_LOCATIONS

Line 3098: FROM mtl_item_locations

3094: stmt_num := 23;
3095: BEGIN
3096: SELECT 'loc exists'
3097: INTO dummy
3098: FROM mtl_item_locations
3099: WHERE inventory_location_id = c3rec.SLI
3100: AND organization_id = c3rec.OI
3101: AND subinventory_code = c3rec.SS
3102: AND nvl(disable_date,trunc(c3rec.EDD)+1) >

Line 3113: FROM mtl_item_locations loc,

3109: stmt_num := 24;
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

Line 3154: FROM mtl_item_locations

3150: IF (r_loc = 2) THEN
3151: BEGIN
3152: SELECT 'loc exists'
3153: INTO dummy
3154: FROM mtl_item_locations
3155: WHERE inventory_location_id = c3rec.SLI
3156: AND organization_id = c3rec.OI
3157: AND subinventory_code = c3rec.SS
3158: AND nvl(disable_date,trunc(c3rec.EDD)+1) >

Line 3170: FROM mtl_item_locations loc,

3166: stmt_num := 26;
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

Line 3215: FROM mtl_item_locations

3211: IF (r_loc = 2) THEN
3212: BEGIN
3213: SELECT 'loc exists'
3214: INTO dummy
3215: FROM mtl_item_locations
3216: WHERE inventory_location_id = c3rec.SLI
3217: AND organization_id = c3rec.OI
3218: AND subinventory_code = c3rec.SS
3219: AND nvl(disable_date,trunc(c3rec.EDD)+1) >

Line 3231: FROM mtl_item_locations loc,

3227: stmt_num := 28;
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

Line 4287: FROM mtl_item_locations

4283: stmt_num := 23;
4284: BEGIN
4285: SELECT 'loc exists'
4286: INTO dummy
4287: FROM mtl_item_locations
4288: WHERE inventory_location_id = c1rec.SLI
4289: AND organization_id = c1rec.OI
4290: AND subinventory_code = c1rec.SS
4291: AND nvl(disable_date,trunc(c1rec.EDD)+1) >

Line 4302: FROM mtl_item_locations loc,

4298: stmt_num := 24;
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

Line 4342: FROM mtl_item_locations

4338: IF (r_loc = 2) THEN
4339: BEGIN
4340: SELECT 'loc exists'
4341: INTO dummy
4342: FROM mtl_item_locations
4343: WHERE inventory_location_id = c1rec.SLI
4344: AND organization_id = c1rec.OI
4345: AND subinventory_code = c1rec.SS
4346: AND nvl(disable_date,trunc(c1rec.EDD)+1) >

Line 4358: FROM mtl_item_locations loc,

4354: stmt_num := 26;
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

Line 4402: FROM mtl_item_locations

4398: IF (r_loc = 2) THEN
4399: BEGIN
4400: SELECT 'loc exists'
4401: INTO dummy
4402: FROM mtl_item_locations
4403: WHERE inventory_location_id = c1rec.SLI
4404: AND organization_id = c1rec.OI
4405: AND subinventory_code = c1rec.SS
4406: AND nvl(disable_date,trunc(c1rec.EDD)+1) >

Line 4418: FROM mtl_item_locations loc,

4414: stmt_num := 28;
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