eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_PHY_INV_LOVS dependencies on MFG_LOOKUPS

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