DBA Data[Home] [Help]

APPS.INV_VALIDATE dependencies on MFG_LOOKUPS

Line 2009: FROM MFG_LOOKUPS

2005: SELECT 'VALID'
2006: INTO l_dummy
2007: FROM MTL_KANBAN_CARDS
2008: WHERE EXISTS (SELECT 1
2009: FROM MFG_LOOKUPS
2010: WHERE LOOKUP_TYPE = 'MTL_TXN_REQUEST_SOURCE'
2011: AND LOOKUP_CODE = p_reference_type_code)
2012: AND KANBAN_CARD_ID = p_reference_id;
2013: END IF;

Line 2062: FROM MFG_LOOKUPS

2058: END IF;
2059:
2060: SELECT 'VALID'
2061: INTO l_dummy
2062: FROM MFG_LOOKUPS
2063: WHERE LOOKUP_TYPE = 'MTL_TXN_REQUEST_SOURCE'
2064: AND LOOKUP_CODE = p_reference_type_code;
2065:
2066: RETURN T;