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 1906: FROM MTL_SERIAL_NUMBERS MSN , MTL_PARAMETERS MP, MFG_LOOKUPS ML

1902: /*Bug7829724-Commeneted locator*/
1903: BEGIN
1904: SELECT 1,MP.ORGANIZATION_CODE,ML.MEANING
1905: INTO l_valid_serial,x_organization_code,x_current_status
1906: FROM MTL_SERIAL_NUMBERS MSN , MTL_PARAMETERS MP, MFG_LOOKUPS ML
1907: WHERE SERIAL_NUMBER like p_serial_num
1908: AND MSN.INVENTORY_ITEM_ID = p_inventory_item_id
1909: AND MSN.CURRENT_ORGANIZATION_ID = p_organization_id
1910: AND MSN.CURRENT_ORGANIZATION_ID = MP.ORGANIZATION_ID

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

1938: * serial should not exist anywhere
1939: */
1940: SELECT MP.ORGANIZATION_CODE,ML.MEANING
1941: INTO x_organization_code,x_current_status
1942: FROM MTL_SERIAL_NUMBERS MSN, MTL_PARAMETERS MP,MFG_LOOKUPS ML
1943: WHERE SERIAL_NUMBER like p_serial_num
1944: AND MSN.CURRENT_ORGANIZATION_ID = MP.ORGANIZATION_ID
1945: AND MSN.CURRENT_STATUS = ML.LOOKUP_CODE
1946: AND ML.LOOKUP_TYPE like 'SERIAL_NUM_STATUS'

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

1951: * serial should not exist in same org, same item
1952: */
1953: SELECT MP.ORGANIZATION_CODE,ML.MEANING
1954: INTO x_organization_code,x_current_status
1955: FROM MTL_SERIAL_NUMBERS MSN, MTL_PARAMETERS MP,MFG_LOOKUPS ML
1956: WHERE MSN.SERIAL_NUMBER like p_serial_num
1957: AND MSN.INVENTORY_ITEM_ID = p_inventory_item_id
1958: AND MSN.CURRENT_ORGANIZATION_ID = MP.ORGANIZATION_ID
1959: AND MSN.CURRENT_STATUS = ML.LOOKUP_CODE

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

1970: BEGIN
1971:
1972: SELECT MP.ORGANIZATION_CODE,ML.MEANING
1973: INTO x_organization_code,x_current_status
1974: FROM MTL_SERIAL_NUMBERS MSN, MTL_PARAMETERS MP,MFG_LOOKUPS ML
1975: WHERE MSN.SERIAL_NUMBER like p_serial_num
1976: AND MSN.INVENTORY_ITEM_ID = p_inventory_item_id
1977: AND MSN.CURRENT_ORGANIZATION_ID = MP.ORGANIZATION_ID
1978: AND MSN.CURRENT_STATUS = ML.LOOKUP_CODE

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

1990: * serial should not exist in same org
1991: */
1992: SELECT MP.ORGANIZATION_CODE,ML.MEANING
1993: INTO x_organization_code,x_current_status
1994: FROM MTL_SERIAL_NUMBERS MSN, MTL_PARAMETERS MP,MFG_LOOKUPS ML
1995: WHERE MSN.SERIAL_NUMBER like p_serial_num
1996: AND MSN.CURRENT_ORGANIZATION_ID = p_organization_id
1997: AND MSN.CURRENT_ORGANIZATION_ID = MP. ORGANIZATION_ID
1998: AND MSN.CURRENT_STATUS = ML.LOOKUP_CODE