APPS.INV_MMX_WRAPPER_PVT dependencies on MFG_LOOKUPS

Line 472: -- (Lookup Type 'MTL_REQUISITION_APPROVAL' defined in MFG_LOOKUPS)

468: --
469: -- From now onwards, Move Orders should also honor
470: -- the profile value set at the profile "INV: Minmax Reorder Approval"
471: -- This profile can have 3 values:
472: -- (Lookup Type 'MTL_REQUISITION_APPROVAL' defined in MFG_LOOKUPS)
473: -- 1- Pre-approve d
474: -- 2- Pre-approve move orders only
475: -- 3- Approval Required
476: --

Line 649: FROM MFG_LOOKUPS

645: --
646: BEGIN
647: SELECT 1
648: INTO l_valid
649: FROM MFG_LOOKUPS
650: WHERE LOOKUP_TYPE = 'MTL_MINMAX_RPT_SORT_BY'
651: AND LOOKUP_CODE = NVL(P_SORT,1);
652: EXCEPTION
653: WHEN no_data_found THEN

Line 668: FROM MFG_LOOKUPS

664: --
665: BEGIN
666: SELECT 1
667: INTO l_valid
668: FROM MFG_LOOKUPS
669: WHERE LOOKUP_TYPE = 'MTL_MINMAX_RPT_SEL'
670: AND LOOKUP_CODE = NVL(P_SELECTION,3);
671: EXCEPTION
672: WHEN no_data_found THEN