DBA Data[Home] [Help]

APPS.INV_LABEL_PVT1 dependencies on MFG_LOOKUPS

Line 85: l_origination_type mfg_lookups.meaning%TYPE := '';

81: FUNCTION get_origination_type (
82: p_origination_type IN NUMBER
83: )
84: RETURN VARCHAR2 IS
85: l_origination_type mfg_lookups.meaning%TYPE := '';
86: BEGIN
87:
88: SELECT meaning
89: into l_origination_type

Line 90: FROM mfg_lookups

86: BEGIN
87:
88: SELECT meaning
89: into l_origination_type
90: FROM mfg_lookups
91: WHERE lookup_type = 'MTL_LOT_ORIGINATION_TYPE'
92: AND lookup_code = p_origination_type;
93:
94: IF SQL%NOTFOUND THEN