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.

[Home] [Help]

APPS.INV_LABEL_PVT5 dependencies on MFG_LOOKUPS

Line 1320: FROM mfg_lookups

1316: -- invconv changes bug 4377633
1317: cursor c_origination_type (p_origination_type NUMBER)
1318: IS
1319: SELECT meaning
1320: FROM mfg_lookups
1321: WHERE lookup_type = 'MTL_LOT_ORIGINATION_TYPE'
1322: AND lookup_code = p_origination_type;
1323: l_origination_type mfg_lookups.meaning%TYPE;
1324:

Line 1323: l_origination_type mfg_lookups.meaning%TYPE;

1319: SELECT meaning
1320: FROM mfg_lookups
1321: WHERE lookup_type = 'MTL_LOT_ORIGINATION_TYPE'
1322: AND lookup_code = p_origination_type;
1323: l_origination_type mfg_lookups.meaning%TYPE;
1324:
1325: l_content_lpn_id NUMBER;
1326: l_transfer_lpn_id NUMBER;
1327: l_from_lpn_id NUMBER;