DBA Data[Home] [Help]

APPS.INV_VALIDATE dependencies on MFG_LOOKUPS

Line 2136: FROM MFG_LOOKUPS

2132: SELECT 'VALID'
2133: INTO l_dummy
2134: FROM MTL_KANBAN_CARDS
2135: WHERE EXISTS (SELECT 1
2136: FROM MFG_LOOKUPS
2137: WHERE LOOKUP_TYPE = 'MTL_TXN_REQUEST_SOURCE'
2138: AND LOOKUP_CODE = p_reference_type_code)
2139: AND KANBAN_CARD_ID = p_reference_id;
2140: END IF;

Line 2189: FROM MFG_LOOKUPS

2185: END IF;
2186:
2187: SELECT 'VALID'
2188: INTO l_dummy
2189: FROM MFG_LOOKUPS
2190: WHERE LOOKUP_TYPE = 'MTL_TXN_REQUEST_SOURCE'
2191: AND LOOKUP_CODE = p_reference_type_code;
2192:
2193: RETURN T;