DBA Data[Home] [Help]

APPS.INV_VIEW_MTL_TXN dependencies on MFG_LOOKUPS

Line 232: FROM MFG_LOOKUPS

228: IF p_TRANSACTION_ACTION_ID IS NOT NULL THEN
229: BEGIN
230: SELECT MEANING
231: INTO x_TRANSACTION_ACTION
232: FROM MFG_LOOKUPS
233: WHERE LOOKUP_TYPE ='MTL_TRANSACTION_ACTION'
234: AND LOOKUP_CODE =p_TRANSACTION_ACTION_ID;
235: EXCEPTION
236: WHEN OTHERS THEN

Line 245: FROM MFG_LOOKUPS

241: BEGIN
242: SELECT MEANING,LOOKUP_CODE
243: INTO x_COSTED_FLAG_1,
244: x_COSTED_LOOKUP_CODE
245: FROM MFG_LOOKUPS
246: WHERE LOOKUP_TYPE ='INV_YES_NO_ERROR'
247: AND LOOKUP_CODE =DECODE(p_COSTED_FLAG,NULL,1,'Y',1,'N',2,'E',3);
248: EXCEPTION
249: WHEN OTHERS THEN

Line 256: FROM MFG_LOOKUPS

252: BEGIN
253: SELECT MEANING,LOOKUP_CODE
254: INTO x_PM_COST_COLLECTED_1,
255: x_PM_COST_COLLECTED_LK_CODE
256: FROM MFG_LOOKUPS
257: WHERE LOOKUP_TYPE ='INV_YES_NO_ERROR_NA'
258: AND LOOKUP_CODE =DECODE (p_PM_COST_COLLECTED, NULL,
259: DECODE(p_PM_COST_COLLECTOR_GROUP_ID,
260: NULL,4,1),