APPS.INV_MWB_QUERY_MANAGER dependencies on MFG_LOOKUPS

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

1403: ,TASK_ID
1404: ,STATUS_ID -- Onhand Material Status Support
1405: FROM MTL_MWB_GTMP;
1406:
1407: TYPE lookup_meaning_table IS TABLE OF mfg_lookups.meaning%TYPE
1408: INDEX BY BINARY_INTEGER;
1409:
1410: document_type_meaning lookup_meaning_table;
1411: lpn_context_meaning lookup_meaning_table;

Line 1452: FROM mfg_lookups

1448:
1449: IF inv_mwb_globals.g_tree_mat_loc_id = 3 THEN
1450: SELECT meaning BULK COLLECT
1451: INTO document_type_meaning
1452: FROM mfg_lookups
1453: WHERE lookup_type = 'MTL_DOCUMENT_TYPES'
1454: ORDER BY lookup_code;
1455: END IF;
1456:

Line 1460: FROM mfg_lookups

1456:
1457:
1458: SELECT meaning BULK COLLECT
1459: INTO lpn_context_meaning
1460: FROM mfg_lookups
1461: WHERE lookup_type = 'WMS_LPN_CONTEXT';
1462:
1463: FOR rec IN C1 LOOP
1464:

Line 1814: FROM mfg_lookups

1810: WHERE lpn_id = rec.lpn_id;
1811:
1812: UPDATE mtl_mwb_gtmp
1813: SET LPN_CONTEXT = (SELECT meaning
1814: FROM mfg_lookups
1815: WHERE lookup_type = 'WMS_LPN_CONTEXT'
1816: AND lookup_code = l_lpn_context_id)
1817: WHERE lpn_id = rec.lpn_id;
1818: END IF;

Line 1896: , mfg_lookups mfg

1892: , mln.supplier_lot_number
1893: , mln.expiration_date
1894: FROM
1895: mtl_lot_numbers mln
1896: , mfg_lookups mfg
1897: WHERE lot_number = rec.lot
1898: AND mln.inventory_item_id = rec.item_id
1899: AND mln.organization_id = rec.org_id
1900: AND mfg.lookup_type = 'MTL_LOT_ORIGINATION_TYPE'