DBA Data[Home] [Help]

APPS.INV_MWB_LOCATION_TREE dependencies on MFG_LOOKUPS

Line 138: FROM mfg_lookups

134: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
135:
136: SELECT meaning
137: BULK COLLECT INTO mtl_loc_type
138: FROM mfg_lookups
139: WHERE lookup_type = 'MTL_LOCATION_TYPES'
140: ORDER BY lookup_code;
141:
142: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Selected all the document types' );

Line 2801: TYPE lookup_meaning_table IS TABLE OF mfg_lookups.meaning%TYPE

2797:
2798: grade_f mtl_material_status_history.grade_code%TYPE ; -- NSRIVAST, INVCONV
2799: l_procedure_name VARCHAR2(30);
2800:
2801: TYPE lookup_meaning_table IS TABLE OF mfg_lookups.meaning%TYPE
2802: INDEX BY BINARY_INTEGER;
2803:
2804: document_type_meaning lookup_meaning_table;
2805: ctr_lookup_code number := 1;

Line 2811: FROM mfg_lookups

2807: l_procedure_name := 'MATLOC_NODE_EVENT';
2808: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Entered');
2809: SELECT meaning
2810: BULK COLLECT INTO document_type_meaning
2811: FROM mfg_lookups
2812: WHERE lookup_type = 'MTL_DOCUMENT_TYPES'
2813: ORDER BY lookup_code;
2814:
2815: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN