APPS.INV_MATERIAL_STATUS_GRP dependencies on MTL_SERIAL_NUMBERS

Line 509: mtl_serial_numbers msn,

505: FROM dual
506: WHERE EXISTS
507: (SELECT 1
508: FROM wms_lpn_contents wlc ,
509: mtl_serial_numbers msn,
510: mtl_status_transaction_control mtc
511: WHERE wlc.parent_lpn_id IN
512: (SELECT lpn_id
513: FROM wms_license_plate_numbers START

Line 1610: from mtl_serial_numbers

1606: if (p_serial_number is not null) and (l_serial_status_enabled = 'Y')
1607: and (p_object_type = 'S' or p_object_type = 'A') then
1608: select status_id
1609: into l_status_id
1610: from mtl_serial_numbers
1611: where inventory_item_id = p_inventory_item_id
1612: and current_organization_id = p_organization_id
1613: and serial_number = p_serial_number;
1614:

Line 2751: FROM mtl_serial_numbers msn

2747: where transaction_temp_id = l_transaction_temp_id;
2748: CURSOR msn_cur(l_cur_lpn_id NUMBER , l_cur_inventory_item_id NUMBER)
2749: IS
2750: SELECT msn.status_id
2751: FROM mtl_serial_numbers msn
2752: where msn.inventory_item_id = l_cur_inventory_item_id
2753: AND msn.lpn_id = l_cur_lpn_id;
2754: CURSOR msnt_cur(l_transaction_temp_id NUMBER)
2755: IS

Line 2757: FROM mtl_serial_numbers msn , mtl_serial_numbers_temp msnt

2753: AND msn.lpn_id = l_cur_lpn_id;
2754: CURSOR msnt_cur(l_transaction_temp_id NUMBER)
2755: IS
2756: SELECT msn.status_id
2757: FROM mtl_serial_numbers msn , mtl_serial_numbers_temp msnt
2758: WHERE msnt.transaction_temp_id = l_transaction_temp_id
2759: AND msn.serial_number BETWEEN msnt.fm_serial_number AND msnt.to_serial_number;
2760:
2761:

Line 3242: FROM mtl_serial_numbers msn

3238:
3239: CURSOR msn_cur(l_cur_lpn_id NUMBER , l_cur_inventory_item_id NUMBER)
3240: IS
3241: SELECT msn.status_id
3242: FROM mtl_serial_numbers msn
3243: where msn.inventory_item_id = l_cur_inventory_item_id
3244: AND msn.lpn_id = l_cur_lpn_id;
3245:
3246: CURSOR mmtt_cur(l_cur_inventory_item_id NUMBER)

Line 3266: FROM mtl_serial_numbers msn , mtl_serial_numbers_temp msnt

3262:
3263: CURSOR msnt_cur(l_transaction_temp_id NUMBER)
3264: IS
3265: SELECT msn.status_id
3266: FROM mtl_serial_numbers msn , mtl_serial_numbers_temp msnt
3267: WHERE msnt.transaction_temp_id = l_transaction_temp_id
3268: AND msn.serial_number BETWEEN msnt.fm_serial_number AND msnt.to_serial_number;
3269:
3270:

Line 3274: -- FROM mtl_serial_numbers msn , mtl_serial_numbers_temp msnt

3270:
3271: -- CURSOR msnt_cur(l_transaction_temp_id NUMBER)
3272: -- IS
3273: -- SELECT msn.status_id
3274: -- FROM mtl_serial_numbers msn , mtl_serial_numbers_temp msnt
3275: -- WHERE msnt.transaction_temp_id = l_transaction_temp_id
3276: -- AND msn.serial_number BETWEEN msnt.fm_serial_number AND msnt.to_serial_number;
3277: BEGIN
3278: IF(g_debug = 1)THEN