APPS.INV_PHY_INV_LOVS dependencies on MTL_SERIAL_NUMBERS

Line 143: FROM mtl_serial_numbers

139: ELSE
140: -- Get the current sub where the serial resides according to the system
141: SELECT NVL(current_subinventory_code, '@@@@@')
142: INTO l_serial_sub
143: FROM mtl_serial_numbers
144: WHERE inventory_item_id = p_inventory_item_id
145: AND serial_number = p_serial_number
146: AND current_organization_id = p_organization_id;
147: IF (l_debug = 1) THEN

Line 1464: FROM MTL_SERIAL_NUMBERS

1460: WHERE parent_lpn_id = l_current_lpn
1461: AND NVL(serial_summary_entry, 2) = 2;
1462: CURSOR lpn_serial_contents_cursor IS
1463: SELECT *
1464: FROM MTL_SERIAL_NUMBERS
1465: WHERE lpn_id = l_current_lpn;
1466:
1467: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1468: BEGIN

Line 1601: UPDATE mtl_serial_numbers

1597: END IF;
1598: x_status := -1;
1599: ELSE
1600:
1601: UPDATE mtl_serial_numbers
1602: SET group_mark_id = -1
1603: WHERE inventory_item_id = p_item_id
1604: AND serial_number in
1605: (SELECT DISTINCT serial_num

Line 1615: print_debug('Updated ' || SQL%ROWCOUNT || ' Records in mtl_serial_numbers for the inventory_item_id ' || p_item_id);

1611: )
1612: AND nvl(group_mark_id,-1) <> -1;
1613:
1614: IF (l_debug = 1) THEN
1615: print_debug('Updated ' || SQL%ROWCOUNT || ' Records in mtl_serial_numbers for the inventory_item_id ' || p_item_id);
1616: print_debug('*** end unmark_serials***');
1617: END IF;
1618:
1619: x_status := 0;

Line 1675: FROM MTL_SERIAL_NUMBERS MSN , MTL_PARAMETERS MP, MFG_LOOKUPS ML

1671: */
1672: BEGIN
1673: SELECT 1,MP.ORGANIZATION_CODE,ML.MEANING
1674: INTO l_valid_serial,x_organization_code,x_current_status
1675: FROM MTL_SERIAL_NUMBERS MSN , MTL_PARAMETERS MP, MFG_LOOKUPS ML
1676: WHERE SERIAL_NUMBER like p_serial_num
1677: AND MSN.INVENTORY_ITEM_ID = p_inventory_item_id
1678: AND MSN.CURRENT_ORGANIZATION_ID = p_organization_id
1679: AND MSN.CURRENT_ORGANIZATION_ID = MP.ORGANIZATION_ID

Line 1711: FROM MTL_SERIAL_NUMBERS MSN, MTL_PARAMETERS MP,MFG_LOOKUPS ML

1707: * serial should not exist anywhere
1708: */
1709: SELECT MP.ORGANIZATION_CODE,ML.MEANING
1710: INTO x_organization_code,x_current_status
1711: FROM MTL_SERIAL_NUMBERS MSN, MTL_PARAMETERS MP,MFG_LOOKUPS ML
1712: WHERE SERIAL_NUMBER like p_serial_num
1713: AND MSN.CURRENT_ORGANIZATION_ID = MP.ORGANIZATION_ID
1714: AND MSN.CURRENT_STATUS = ML.LOOKUP_CODE
1715: AND ML.LOOKUP_TYPE like 'SERIAL_NUM_STATUS'

Line 1724: FROM MTL_SERIAL_NUMBERS MSN, MTL_PARAMETERS MP,MFG_LOOKUPS ML

1720: * serial should not exist in same org, same item
1721: */
1722: SELECT MP.ORGANIZATION_CODE,ML.MEANING
1723: INTO x_organization_code,x_current_status
1724: FROM MTL_SERIAL_NUMBERS MSN, MTL_PARAMETERS MP,MFG_LOOKUPS ML
1725: WHERE MSN.SERIAL_NUMBER like p_serial_num
1726: AND MSN.INVENTORY_ITEM_ID = p_inventory_item_id
1727: AND MSN.CURRENT_ORGANIZATION_ID = MP.ORGANIZATION_ID
1728: AND MSN.CURRENT_STATUS = ML.LOOKUP_CODE

Line 1743: FROM MTL_SERIAL_NUMBERS MSN, MTL_PARAMETERS MP,MFG_LOOKUPS ML

1739: BEGIN
1740:
1741: SELECT MP.ORGANIZATION_CODE,ML.MEANING
1742: INTO x_organization_code,x_current_status
1743: FROM MTL_SERIAL_NUMBERS MSN, MTL_PARAMETERS MP,MFG_LOOKUPS ML
1744: WHERE MSN.SERIAL_NUMBER like p_serial_num
1745: AND MSN.INVENTORY_ITEM_ID = p_inventory_item_id
1746: AND MSN.CURRENT_ORGANIZATION_ID = MP.ORGANIZATION_ID
1747: AND MSN.CURRENT_STATUS = ML.LOOKUP_CODE

Line 1763: FROM MTL_SERIAL_NUMBERS MSN, MTL_PARAMETERS MP,MFG_LOOKUPS ML

1759: * serial should not exist in same org
1760: */
1761: SELECT MP.ORGANIZATION_CODE,ML.MEANING
1762: INTO x_organization_code,x_current_status
1763: FROM MTL_SERIAL_NUMBERS MSN, MTL_PARAMETERS MP,MFG_LOOKUPS ML
1764: WHERE MSN.SERIAL_NUMBER like p_serial_num
1765: AND MSN.CURRENT_ORGANIZATION_ID = p_organization_id
1766: AND MSN.CURRENT_ORGANIZATION_ID = MP. ORGANIZATION_ID
1767: AND MSN.CURRENT_STATUS = ML.LOOKUP_CODE