APPS.INV_MATERIAL_STATUS_GRP dependencies on MTL_SERIAL_NUMBERS

Line 307: FROM mtl_serial_numbers msn

303: AND plpn.organization_id = p_organization_id
304: )
305: UNION --bug 10427776
306: SELECT DISTINCT msn.status_id
307: FROM mtl_serial_numbers msn
308: where msn.current_subinventory_code = p_sub_code
309: and msn.current_locator_id = p_locator_id
310: and msn.current_organization_id=p_organization_id
311: and msn.lpn_id = p_fromlpn_id

Line 330: FROM mtl_serial_numbers msn

326: )
327: )
328: UNION --bug 10427776
329: SELECT DISTINCT msn.status_id
330: FROM mtl_serial_numbers msn
331: where msn.current_subinventory_code = p_sub_code
332: and msn.current_locator_id = p_locator_id
333: and msn.current_organization_id=l_xfer_org_id
334: and msn.lpn_id = p_xfer_lpn_id

Line 523: mtl_serial_numbers msn,

519: FROM dual
520: WHERE EXISTS
521: (SELECT 1
522: FROM wms_lpn_contents wlc ,
523: mtl_serial_numbers msn,
524: mtl_status_transaction_control mtc
525: WHERE wlc.parent_lpn_id IN
526: (SELECT lpn_id
527: FROM wms_license_plate_numbers START

Line 1933: FROM mtl_serial_numbers

1929: /* Bug 7157303 Added below query in BEGIN-EXCEPTION-END block and added exception code */
1930: BEGIN
1931: SELECT status_id
1932: INTO l_status_id
1933: FROM mtl_serial_numbers
1934: WHERE inventory_item_id = p_inventory_item_id
1935: AND current_organization_id = p_organization_id
1936: AND serial_number = p_serial_number;
1937:

Line 3282: FROM mtl_serial_numbers msn

3278: where transaction_temp_id = l_transaction_temp_id;
3279: CURSOR msn_cur(l_cur_lpn_id NUMBER , l_cur_inventory_item_id NUMBER)
3280: IS
3281: SELECT msn.status_id
3282: FROM mtl_serial_numbers msn
3283: where msn.inventory_item_id = l_cur_inventory_item_id
3284: AND msn.lpn_id = l_cur_lpn_id;
3285: CURSOR msnt_cur(l_transaction_temp_id NUMBER)
3286: IS

Line 3288: FROM mtl_serial_numbers msn , mtl_serial_numbers_temp msnt

3284: AND msn.lpn_id = l_cur_lpn_id;
3285: CURSOR msnt_cur(l_transaction_temp_id NUMBER)
3286: IS
3287: SELECT msn.status_id
3288: FROM mtl_serial_numbers msn , mtl_serial_numbers_temp msnt
3289: WHERE msnt.transaction_temp_id = l_transaction_temp_id
3290: AND msn.serial_number BETWEEN msnt.fm_serial_number AND msnt.to_serial_number;
3291:
3292:

Line 3778: FROM mtl_serial_numbers msn

3774:
3775: CURSOR msn_cur(l_cur_lpn_id NUMBER , l_cur_inventory_item_id NUMBER)
3776: IS
3777: SELECT msn.status_id
3778: FROM mtl_serial_numbers msn
3779: where msn.inventory_item_id = l_cur_inventory_item_id
3780: AND msn.lpn_id = l_cur_lpn_id;
3781:
3782: CURSOR mmtt_cur(l_cur_inventory_item_id NUMBER)

Line 3802: FROM mtl_serial_numbers msn , mtl_serial_numbers_temp msnt

3798:
3799: CURSOR msnt_cur(l_transaction_temp_id NUMBER)
3800: IS
3801: SELECT msn.status_id
3802: FROM mtl_serial_numbers msn , mtl_serial_numbers_temp msnt
3803: WHERE msnt.transaction_temp_id = l_transaction_temp_id
3804: AND msn.serial_number BETWEEN msnt.fm_serial_number AND msnt.to_serial_number;
3805:
3806:

Line 3810: -- FROM mtl_serial_numbers msn , mtl_serial_numbers_temp msnt

3806:
3807: -- CURSOR msnt_cur(l_transaction_temp_id NUMBER)
3808: -- IS
3809: -- SELECT msn.status_id
3810: -- FROM mtl_serial_numbers msn , mtl_serial_numbers_temp msnt
3811: -- WHERE msnt.transaction_temp_id = l_transaction_temp_id
3812: -- AND msn.serial_number BETWEEN msnt.fm_serial_number AND msnt.to_serial_number;
3813: BEGIN
3814: IF(g_debug = 1)THEN