DBA Data[Home] [Help]

APPS.INV_LABEL_PVT5 dependencies on MFG_LOOKUPS

Line 1172: FROM mfg_lookups

1168: -- invconv changes bug 4377633
1169: cursor c_origination_type (p_origination_type NUMBER)
1170: IS
1171: SELECT meaning
1172: FROM mfg_lookups
1173: WHERE lookup_type = 'MTL_LOT_ORIGINATION_TYPE'
1174: AND lookup_code = p_origination_type;
1175: l_origination_type mfg_lookups.meaning%TYPE;
1176:

Line 1175: l_origination_type mfg_lookups.meaning%TYPE;

1171: SELECT meaning
1172: FROM mfg_lookups
1173: WHERE lookup_type = 'MTL_LOT_ORIGINATION_TYPE'
1174: AND lookup_code = p_origination_type;
1175: l_origination_type mfg_lookups.meaning%TYPE;
1176:
1177: l_content_lpn_id NUMBER;
1178: l_transfer_lpn_id NUMBER;
1179: l_from_lpn_id NUMBER;