DBA Data[Home] [Help]

APPS.INV_MWB_LOCATION_TREE dependencies on MFG_LOOKUPS

Line 137: FROM mfg_lookups

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

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

2503:
2504: grade_f mtl_material_status_history.grade_code%TYPE ; -- NSRIVAST, INVCONV
2505: l_procedure_name VARCHAR2(30);
2506:
2507: TYPE lookup_meaning_table IS TABLE OF mfg_lookups.meaning%TYPE
2508: INDEX BY BINARY_INTEGER;
2509:
2510: document_type_meaning lookup_meaning_table;
2511: ctr_lookup_code number := 1;

Line 2517: FROM mfg_lookups

2513: l_procedure_name := 'MATLOC_NODE_EVENT';
2514: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Entered');
2515: SELECT meaning
2516: BULK COLLECT INTO document_type_meaning
2517: FROM mfg_lookups
2518: WHERE lookup_type = 'MTL_DOCUMENT_TYPES'
2519: ORDER BY lookup_code;
2520:
2521: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN