APPS.INV_SERIAL_NUMBER_PUB dependencies on MTL_SYSTEM_ITEMS

Line 241: FROM mtl_system_items

237: SELECT serial_number_control_code
238: , eam_item_type
239: INTO l_serial_control_code
240: , eam_item
241: FROM mtl_system_items
242: WHERE inventory_item_id = p_inventory_item_id
243: AND organization_id = p_organization_id;
244:
245: IF (l_serial_control_code = 1

Line 505: FROM mtl_system_items

501: /**ELSE**/
502: BEGIN
503: SELECT serial_number_control_code
504: INTO l_serial_control_code
505: FROM mtl_system_items
506: WHERE inventory_item_id = p_inventory_item_id
507: AND organization_id = p_organization_id;
508:
509: -- invtrace('serial_number_control_code is ' || l_serial_control_code);

Line 911: -- specified in the mtl_system_items

907: g_serial_attributes_tbl(1).column_value := NULL;
908: END IF;
909:
910: -- if the p_status_id is null, then default the status if it is
911: -- specified in the mtl_system_items
912: -- invtrace('p_status_id is ' || p_status_id);
913: IF p_status_id IS NULL THEN
914: -- invtrace('p_status_id is null. calling inv_material_status_grp.get_lot_serial_status_control');
915: inv_material_status_grp.get_lot_serial_status_control(

Line 1384: FROM mtl_system_items

1380: -- Block to check the Serial Control Code
1381: BEGIN
1382: SELECT serial_number_control_code
1383: INTO l_serial_control_code
1384: FROM mtl_system_items
1385: WHERE inventory_item_id = p_inventory_item_id
1386: AND organization_id = p_organization_id;
1387:
1388: IF (l_serial_control_code = 1) THEN

Line 6467: FROM mtl_system_items

6463: IF p_serial_control IS NULL THEN
6464:
6465: SELECT serial_number_control_code
6466: INTO l_serial_control_code
6467: FROM mtl_system_items
6468: WHERE inventory_item_id = p_inventory_item_id
6469: AND organization_id = p_organization_id;
6470: ELSE
6471: l_serial_control_code := p_serial_control;

Line 6491: FROM mtl_system_items

6487:
6488: BEGIN
6489: SELECT serial_number_control_code
6490: INTO l_xfer_serial_control_code
6491: FROM mtl_system_items
6492: WHERE inventory_item_id = p_inventory_item_id
6493: AND organization_id = p_transfer_org_id;
6494: EXCEPTION
6495: WHEN No_Data_Found THEN