DBA Data[Home] [Help]

APPS.INV_MMX_WRAPPER_PVT dependencies on MFG_LOOKUPS

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

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

Line 653: FROM MFG_LOOKUPS

649: --
650: BEGIN
651: SELECT 1
652: INTO l_valid
653: FROM MFG_LOOKUPS
654: WHERE LOOKUP_TYPE = 'MTL_MINMAX_RPT_SORT_BY'
655: AND LOOKUP_CODE = NVL(P_SORT,1);
656: EXCEPTION
657: WHEN no_data_found THEN

Line 672: FROM MFG_LOOKUPS

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