APPS.INV_MWB_QUERY_MANAGER dependencies on MFG_LOOKUPS

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

1440: ,TASK_ID
1441: ,STATUS_ID -- Onhand Material Status Support
1442: FROM MTL_MWB_GTMP;
1443:
1444: TYPE lookup_meaning_table IS TABLE OF mfg_lookups.meaning%TYPE
1445: INDEX BY BINARY_INTEGER;
1446:
1447: document_type_meaning lookup_meaning_table;
1448: lpn_context_meaning lookup_meaning_table;

Line 1499: FROM mfg_lookups

1495:
1496: IF inv_mwb_globals.g_tree_mat_loc_id = 3 THEN
1497: SELECT meaning BULK COLLECT
1498: INTO document_type_meaning
1499: FROM mfg_lookups
1500: WHERE lookup_type = 'MTL_DOCUMENT_TYPES'
1501: ORDER BY lookup_code;
1502: END IF;
1503:

Line 1507: FROM mfg_lookups

1503:
1504:
1505: SELECT meaning BULK COLLECT
1506: INTO lpn_context_meaning
1507: FROM mfg_lookups
1508: WHERE lookup_type = 'WMS_LPN_CONTEXT';
1509:
1510: FOR rec IN C1 LOOP
1511:

Line 1916: FROM mfg_lookups

1912: WHERE lpn_id = rec.lpn_id;
1913:
1914: UPDATE mtl_mwb_gtmp
1915: SET LPN_CONTEXT = (SELECT meaning
1916: FROM mfg_lookups
1917: WHERE lookup_type = 'WMS_LPN_CONTEXT'
1918: AND lookup_code = l_lpn_context_id)
1919: WHERE lpn_id = rec.lpn_id;
1920: END IF;

Line 1971: /* Bug 8396954. adding outerjoin condition for mfg_lookups table to get the records

1967: if ( (nvl(g_lot, '@@@@') <> rec.lot)
1968: or (nvl(g_item_id,-9999) <> nvl(rec.item_id, -9999))
1969: or (nvl(g_org_id,-9999) <> nvl(rec.org_id, -9999))
1970: ) then
1971: /* Bug 8396954. adding outerjoin condition for mfg_lookups table to get the records
1972: even if the origination_type in mtl_lot_numbers is null */
1973: UPDATE MTL_MWB_GTMP
1974: SET (
1975: ORIGINATION_TYPE

Line 1999: , mfg_lookups mfg

1995: , mln.supplier_lot_number
1996: , mln.expiration_date
1997: FROM
1998: mtl_lot_numbers mln
1999: , mfg_lookups mfg
2000: WHERE lot_number = rec.lot
2001: AND mln.inventory_item_id = rec.item_id
2002: AND mln.organization_id = rec.org_id
2003: AND mfg.lookup_type(+) = 'MTL_LOT_ORIGINATION_TYPE'