2994: stmt_num := 18;
2995: BEGIN
2996: SELECT locator_type
2997: INTO sub_loc_code
2998: FROM mtl_secondary_inventories
2999: WHERE secondary_inventory_name = c3rec.SS
3000: AND organization_id = c3rec.OI
3001: AND nvl(disable_date,TRUNC(c3rec.EDD)+1) >
3002: TRUNC(c3rec.EDD)
3009: stmt_num := 19;
3010: BEGIN
3011: SELECT locator_type
3012: INTO sub_loc_code
3013: FROM mtl_secondary_inventories
3014: WHERE secondary_inventory_name = c3rec.SS
3015: AND organization_id = c3rec.OI
3016: AND nvl(disable_date,TRUNC(c3rec.EDD)+1) >
3017: TRUNC(c3rec.EDD)
3029: stmt_num := 20;
3030: BEGIN
3031: SELECT locator_type
3032: INTO sub_loc_code
3033: FROM mtl_secondary_inventories sub,
3034: mtl_item_sub_inventories item
3035: WHERE item.organization_id = sub.organization_id
3036: AND item.secondary_inventory =
3037: sub.secondary_inventory_name
3049: stmt_num := 21;
3050: BEGIN
3051: SELECT locator_type
3052: INTO sub_loc_code
3053: FROM mtl_secondary_inventories sub,
3054: mtl_item_sub_inventories item
3055: WHERE item.organization_id = sub.organization_id
3056: AND item.secondary_inventory =
3057: sub.secondary_inventory_name
4184: stmt_num := 18;
4185: BEGIN
4186: SELECT locator_type
4187: INTO sub_loc_code
4188: FROM mtl_secondary_inventories
4189: WHERE secondary_inventory_name = c1rec.SS
4190: AND organization_id = c1rec.OI
4191: AND nvl(disable_date,TRUNC(c1rec.EDD)+1) >
4192: TRUNC(c1rec.EDD)
4199: stmt_num := 19;
4200: BEGIN
4201: SELECT locator_type
4202: INTO sub_loc_code
4203: FROM mtl_secondary_inventories
4204: WHERE secondary_inventory_name = c1rec.SS
4205: AND organization_id = c1rec.OI
4206: AND nvl(disable_date,TRUNC(c1rec.EDD)+1) >
4207: TRUNC(c1rec.EDD)
4219: stmt_num := 20;
4220: BEGIN
4221: SELECT locator_type
4222: INTO sub_loc_code
4223: FROM mtl_secondary_inventories sub,
4224: mtl_item_sub_inventories item
4225: WHERE item.organization_id = sub.organization_id
4226: AND item.secondary_inventory =
4227: sub.secondary_inventory_name
4239: stmt_num := 21;
4240: BEGIN
4241: SELECT locator_type
4242: INTO sub_loc_code
4243: FROM mtl_secondary_inventories sub,
4244: mtl_item_sub_inventories item
4245: WHERE item.organization_id = sub.organization_id
4246: AND item.secondary_inventory =
4247: sub.secondary_inventory_name