APPS.INV_LOT_ATTR_PUB dependencies on MFG_LOOKUPS

Line 493: -- Must exist in mfg_lookups (lookup_type = 'ORIGINATION_TYPE')

489: -----------------------------------------------------------------------
490: -- Name : validate_origination_type
491: -- Desc :
492: -- Generic routine to validate origination type
493: -- Must exist in mfg_lookups (lookup_type = 'ORIGINATION_TYPE')
494: --
495: -- I/P params :
496: -- p_origination_id (Mandatory)
497: -----------------------------------------------------------------------

Line 510: FROM mfg_lookups

506:
507: /* Origination Type validation logic */
508: CURSOR c_get_origination_type IS
509: SELECT lookup_code
510: FROM mfg_lookups
511: WHERE lookup_type = 'MTL_LOT_ORIGINATION_TYPE'
512: AND lookup_code = p_origination_type;
513:
514: BEGIN