eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_MWB_QUERY_MANAGER dependencies on MTL_MWB_GTMP

Line 108: l_insert_str := 'INSERT INTO mtl_mwb_gtmp (';

104: BEGIN
105:
106: l_procedure_name := 'BUILD_INSERT';
107: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Entered');
108: l_insert_str := 'INSERT INTO mtl_mwb_gtmp (';
109: -- inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, l_insert_str);
110: l_pos := p_columns.FIRST;
111: WHILE l_pos IS NOT NULL LOOP
112: IF l_pos = p_columns.FIRST THEN

Line 1405: FROM MTL_MWB_GTMP;

1401: ,OWNING_TP_TYPE
1402: ,PROJECT_ID
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:

Line 1471: UPDATE MTL_MWB_GTMP

1467: IF inv_mwb_globals.g_organization_code IS NOT NULL
1468: AND inv_mwb_globals.g_organization_id IS NOT NULL THEN
1469: --Bug 6834805
1470: if (nvl(g_org,'@@@@') <> inv_mwb_globals.g_organization_code) then
1471: UPDATE MTL_MWB_GTMP
1472: SET organization_code = inv_mwb_globals.g_organization_code;
1473:
1474: g_org := inv_mwb_globals.g_organization_code;
1475: end if;

Line 1485: UPDATE MTL_MWB_GTMP

1481: INTO l_to_org
1482: FROM mtl_parameters
1483: WHERE organization_id = rec.org_id;
1484:
1485: UPDATE MTL_MWB_GTMP
1486: SET organization_code = l_to_org
1487: , to_org = l_to_org
1488: WHERE org_id = rec.org_id;
1489:

Line 1498: UPDATE MTL_MWB_GTMP

1494:
1495: IF inv_mwb_globals.g_subinventory_code IS NOT NULL THEN
1496: --Bug 6834805
1497: if (nvl(g_sub,'@@@@') <> inv_mwb_globals.g_subinventory_code) then
1498: UPDATE MTL_MWB_GTMP
1499: SET SUBINVENTORY_CODE = inv_mwb_globals.g_subinventory_code;
1500:
1501: g_sub := inv_mwb_globals.g_subinventory_code;
1502: end if;

Line 1508: UPDATE MTL_MWB_GTMP

1504:
1505: IF rec.owning_org_id IS NOT NULL THEN
1506: --Bug 6834805
1507: if (nvl(g_own_org_id,-9999) <> rec.owning_org_id) then
1508: UPDATE MTL_MWB_GTMP
1509: SET owning_org = (SELECT organization_code
1510: FROM mtl_parameters
1511: WHERE organization_id = rec.owning_org_id)
1512: WHERE owning_org_id = rec.owning_org_id;

Line 1522: UPDATE MTL_MWB_GTMP

1518: ----------------- Update LPN ------------------------------------------
1519:
1520: IF rec.lpn_id IS NOT NULL THEN
1521: BEGIN
1522: UPDATE MTL_MWB_GTMP
1523: SET lpn = (SELECT license_plate_number
1524: FROM wms_license_plate_numbers
1525: WHERE lpn_id = rec.lpn_id)
1526: WHERE lpn_id = rec.lpn_id;

Line 1528: UPDATE MTL_MWB_GTMP

1524: FROM wms_license_plate_numbers
1525: WHERE lpn_id = rec.lpn_id)
1526: WHERE lpn_id = rec.lpn_id;
1527:
1528: UPDATE MTL_MWB_GTMP
1529: SET loaded = (SELECT 1
1530: FROM mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt
1531: WHERE wdt.status = 4
1532: AND wdt.task_type <> 2

Line 1540: UPDATE MTL_MWB_GTMP

1536: WHERE lpn_id = rec.lpn_id;
1537:
1538: EXCEPTION
1539: WHEN TOO_MANY_ROWS THEN
1540: UPDATE MTL_MWB_GTMP
1541: SET LOADED = 1
1542: WHERE lpn_id = rec.lpn_id;
1543: END;
1544: END IF;

Line 1552: UPDATE MTL_MWB_GTMP

1548: IF inv_mwb_globals.g_cost_group IS NOT NULL
1549: AND inv_mwb_globals.g_cost_group_id IS NOT NULL THEN
1550: --Bug 6834805
1551: if (nvl(g_cg,'@@@@') <> inv_mwb_globals.g_cost_group) then
1552: UPDATE MTL_MWB_GTMP
1553: SET cost_group = inv_mwb_globals.g_cost_group;
1554:
1555: g_cg := inv_mwb_globals.g_cost_group;
1556: end if;

Line 1561: UPDATE MTL_MWB_GTMP

1557: ELSE
1558: IF rec.cg_id IS NOT NULL THEN
1559: --Bug 6834805
1560: if (nvl(g_cg_id,-9999) <> rec.cg_id) then
1561: UPDATE MTL_MWB_GTMP
1562: SET cost_group = (SELECT distinct cost_group
1563: FROM cst_cost_groups
1564: WHERE cost_group_id = rec.cg_id)
1565: WHERE cg_id = rec.cg_id;

Line 1579: UPDATE MTL_MWB_GTMP

1575: l_item_name := inv_mwb_tree1.GET_ITEM(rec.item_id, rec.org_id); -- Bug 6350236
1576: --Bug 6834805
1577: if (nvl(g_item_id,-9999) <> rec.item_id) then
1578:
1579: UPDATE MTL_MWB_GTMP
1580: SET (
1581: ITEM
1582: , ITEM_DESCRIPTION
1583: , PRIMARY_UOM_CODE

Line 1604: UPDATE MTL_MWB_GTMP

1600: IF inv_mwb_globals.g_locator_name IS NOT NULL
1601: AND inv_mwb_globals.g_locator_id IS NOT NULL THEN
1602: --Bug 6834805
1603: if (nvl(g_loc, '@@@@') <> inv_mwb_globals.g_locator_name) then
1604: UPDATE MTL_MWB_GTMP
1605: SET locator = substr(inv_mwb_globals.g_locator_name, 1, 100),--Bug6595049: truncating the locator to 100 chars
1606: locator_id = inv_mwb_globals.g_locator_id; -- Bug 7408480
1607:
1608: g_loc := inv_mwb_globals.g_locator_name;

Line 1616: UPDATE MTL_MWB_GTMP

1612: --Bug 6834805
1613: if (nvl(g_loc_id, -9999) <> rec.locator_id) then
1614:
1615: IF inv_mwb_globals.g_is_projects_enabled_org = 0 THEN
1616: UPDATE MTL_MWB_GTMP
1617: SET locator = substr((SELECT concatenated_segments
1618: FROM mtl_item_locations_kfv
1619: WHERE inventory_location_id = rec.locator_id), 1, 100) -- Bug 6595049: truncating the locator to 100 chars
1620: WHERE locator_id = rec.locator_id;

Line 1624: UPDATE MTL_MWB_GTMP

1620: WHERE locator_id = rec.locator_id;
1621: ELSE
1622: l_project_id := NULL;
1623: l_task_id := NULL;
1624: UPDATE MTL_MWB_GTMP
1625: SET LOCATOR = substr(INV_PROJECT.GET_LOCATOR(REC.LOCATOR_ID, REC.ORG_ID), 1, 100) -- Bug 6595049: truncating the locator to 100 chars
1626: WHERE locator_id = rec.locator_id;
1627:
1628: SELECT project_id

Line 1637: UPDATE MTL_MWB_GTMP

1633: WHERE inventory_location_id = rec.locator_id
1634: AND organization_id = rec.org_id;
1635:
1636: IF inv_mwb_globals.g_project_number IS NOT NULL THEN
1637: UPDATE MTL_MWB_GTMP
1638: SET project_number = inv_mwb_globals.g_project_number;
1639: ELSE
1640: IF l_project_id IS NOT NULL THEN
1641: UPDATE MTL_MWB_GTMP

Line 1641: UPDATE MTL_MWB_GTMP

1637: UPDATE MTL_MWB_GTMP
1638: SET project_number = inv_mwb_globals.g_project_number;
1639: ELSE
1640: IF l_project_id IS NOT NULL THEN
1641: UPDATE MTL_MWB_GTMP
1642: SET project_number = (SELECT project_number
1643: FROM pjm_projects_v
1644: WHERE project_id = l_project_id)
1645: WHERE locator_id = rec.locator_id;

Line 1650: UPDATE MTL_MWB_GTMP

1646: END IF;
1647: END IF;
1648:
1649: IF inv_mwb_globals.g_task_number IS NOT NULL THEN
1650: UPDATE MTL_MWB_GTMP
1651: SET task_number = inv_mwb_globals.g_task_number;
1652: ELSE
1653: IF rec.task_id IS NOT NULL THEN
1654: UPDATE MTL_MWB_GTMP

Line 1654: UPDATE MTL_MWB_GTMP

1650: UPDATE MTL_MWB_GTMP
1651: SET task_number = inv_mwb_globals.g_task_number;
1652: ELSE
1653: IF rec.task_id IS NOT NULL THEN
1654: UPDATE MTL_MWB_GTMP
1655: SET task_number = (SELECT task_number
1656: FROM pjm_tasks_v
1657: WHERE task_id = rec.task_id)
1658: WHERE locator_id = rec.locator_id;

Line 1679: UPDATE mtl_mwb_gtmp

1675: INTO l_shipment_num, l_shipped_date
1676: FROM rcv_shipment_headers rsh
1677: WHERE rsh.shipment_header_id = rec.shipment_header_id_asn;
1678:
1679: UPDATE mtl_mwb_gtmp
1680: SET document_number = l_shipment_num
1681: , shipped_date = l_shipped_date
1682: , document_type = l_mtl_location
1683: , document_type_id = 4

Line 1687: UPDATE mtl_mwb_gtmp

1683: , document_type_id = 4
1684: WHERE shipment_header_id_asn = rec.shipment_header_id_asn;
1685:
1686: IF rec.document_line_number IS NOT NULL THEN
1687: UPDATE mtl_mwb_gtmp
1688: SET document_line_number = (SELECT line_num
1689: FROM rcv_shipment_lines rsl
1690: WHERE rsl.shipment_line_id = rec.document_line_number)
1691: WHERE shipment_header_id_asn = rec.shipment_header_id_asn

Line 1696: UPDATE mtl_mwb_gtmp

1692: AND document_line_number = rec.document_line_number;
1693: END IF;
1694: ELSE -- PO
1695: l_mtl_location := document_type_meaning(1);
1696: UPDATE mtl_mwb_gtmp
1697: SET document_number = (SELECT segment1
1698: FROM po_headers_all pha
1699: WHERE pha.po_header_id = rec.po_header_id)
1700: , document_type = l_mtl_location

Line 1705: UPDATE mtl_mwb_gtmp

1701: , document_type_id = 1
1702: WHERE po_header_id = rec.po_header_id;
1703:
1704: IF rec.document_line_number IS NOT NULL THEN
1705: UPDATE mtl_mwb_gtmp
1706: SET document_line_number = (SELECT line_num
1707: FROM po_lines_all pla
1708: WHERE pla.po_line_id = rec.document_line_number)
1709: WHERE po_header_id = rec.po_header_id

Line 1715: UPDATE mtl_mwb_gtmp

1711: END IF;
1712: END IF;
1713: ELSIF rec.req_header_id IS NOT NULL THEN -- Req
1714: l_mtl_location := document_type_meaning(2);
1715: UPDATE mtl_mwb_gtmp
1716: SET document_number = (SELECT segment1
1717: FROM po_requisition_headers_all prha
1718: WHERE prha.requisition_header_id = rec.req_header_id)
1719: , document_type = l_mtl_location

Line 1724: UPDATE mtl_mwb_gtmp

1720: , document_type_id = 2
1721: WHERE req_header_id = rec.req_header_id;
1722:
1723: IF rec.document_line_number IS NOT NULL THEN
1724: UPDATE mtl_mwb_gtmp
1725: SET document_line_number = (SELECT line_num
1726: FROM po_requisition_lines_all prla
1727: WHERE prla.requisition_line_id = rec.document_line_number)
1728: WHERE req_header_id = rec.req_header_id

Line 1734: UPDATE mtl_mwb_gtmp

1730: END IF;
1731: ELSIF rec.shipment_header_id_asn IS NOT NULL THEN -- Interorg
1732: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, rec.shipment_header_id_asn);
1733: l_mtl_location := document_type_meaning(3);
1734: UPDATE mtl_mwb_gtmp
1735: SET document_number = (SELECT shipment_num
1736: FROM rcv_shipment_headers rsh
1737: WHERE rsh.shipment_header_id = rec.shipment_header_id_asn)
1738: , document_type = l_mtl_location

Line 1743: UPDATE mtl_mwb_gtmp

1739: , document_type_id = 3
1740: WHERE shipment_header_id_asn = rec.shipment_header_id_asn;
1741:
1742: IF rec.document_line_number IS NOT NULL THEN
1743: UPDATE mtl_mwb_gtmp
1744: SET document_line_number = (SELECT line_num
1745: FROM rcv_shipment_lines rsl
1746: WHERE rsl.shipment_line_id = rec.document_line_number)
1747: WHERE shipment_header_id_asn = rec.shipment_header_id_asn

Line 1765: UPDATE mtl_mwb_gtmp

1761: , l_vendor_site_id
1762: FROM po_headers_all
1763: WHERE po_header_id = rec.po_header_id;
1764:
1765: UPDATE mtl_mwb_gtmp
1766: SET vendor_id = l_vendor_id
1767: , vendor_site_id = l_vendor_site_id
1768: WHERE po_header_id = rec.po_header_id;
1769: END IF;

Line 1773: UPDATE mtl_mwb_gtmp

1769: END IF;
1770:
1771: IF rec.vendor_id IS NOT NULL
1772: OR l_vendor_id IS NOT NULL THEN
1773: UPDATE mtl_mwb_gtmp
1774: SET trading_partner = (SELECT vendor_name
1775: FROM po_vendors
1776: WHERE vendor_id = l_vendor_id)
1777: WHERE vendor_id = l_vendor_id;

Line 1781: UPDATE mtl_mwb_gtmp

1777: WHERE vendor_id = l_vendor_id;
1778:
1779: IF rec.vendor_site_id IS NOT NULL
1780: OR l_vendor_site_id IS NOT NULL THEN
1781: UPDATE mtl_mwb_gtmp
1782: SET trading_partner_site = (SELECT vendor_site_code
1783: FROM po_vendor_sites_all
1784: WHERE vendor_site_id = l_vendor_site_id)
1785: WHERE vendor_id = l_vendor_id

Line 1801: UPDATE mtl_mwb_gtmp

1797: inv_mwb_globals.g_chk_inbound = 0 AND
1798: inv_mwb_globals.g_chk_onhand = 0
1799: ) OR inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
1800:
1801: UPDATE mtl_mwb_gtmp
1802: SET LPN_CONTEXT = lpn_context_meaning(3)
1803: WHERE lpn_id = rec.lpn_id;
1804: ELSE
1805: */

Line 1812: UPDATE mtl_mwb_gtmp

1808: INTO l_lpn_context_id
1809: FROM wms_license_plate_numbers
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)

Line 1822: UPDATE mtl_mwb_gtmp

1818: END IF;
1819: -- END IF;
1820:
1821: IF inv_mwb_globals.g_tree_doc_type_id = 4 THEN
1822: UPDATE mtl_mwb_gtmp
1823: SET document_type = document_type_meaning(4)
1824: , document_type_id = 4
1825: WHERE shipment_header_id_asn = rec.shipment_header_id_asn;
1826: END IF;

Line 1831: UPDATE mtl_mwb_gtmp

1827:
1828: IF rec.planning_tp_type = 1
1829: AND rec.planning_organization_id IS NOT NULL THEN
1830: IF inv_mwb_globals.g_planning_party IS NOT NULL THEN
1831: UPDATE mtl_mwb_gtmp
1832: SET planning_party = inv_mwb_globals.g_planning_party;
1833: ELSE
1834: UPDATE mtl_mwb_gtmp
1835: SET planning_party = (SELECT vendor_name || '-' || vendor_site_code

Line 1834: UPDATE mtl_mwb_gtmp

1830: IF inv_mwb_globals.g_planning_party IS NOT NULL THEN
1831: UPDATE mtl_mwb_gtmp
1832: SET planning_party = inv_mwb_globals.g_planning_party;
1833: ELSE
1834: UPDATE mtl_mwb_gtmp
1835: SET planning_party = (SELECT vendor_name || '-' || vendor_site_code
1836: FROM po_vendor_sites_all ps, po_vendors pv
1837: WHERE pv.vendor_id = ps.vendor_id
1838: AND ps.vendor_site_id = rec.planning_organization_id)

Line 1847: UPDATE mtl_mwb_gtmp

1843: IF rec.owning_tp_type = 1
1844: AND rec.owning_organization_id IS NOT NULL THEN
1845:
1846: IF inv_mwb_globals.g_owning_party IS NOT NULL THEN
1847: UPDATE mtl_mwb_gtmp
1848: SET owning_party = inv_mwb_globals.g_owning_party;
1849: ELSE
1850: UPDATE mtl_mwb_gtmp
1851: SET owning_party = (SELECT vendor_name || '-' || vendor_site_code

Line 1850: UPDATE mtl_mwb_gtmp

1846: IF inv_mwb_globals.g_owning_party IS NOT NULL THEN
1847: UPDATE mtl_mwb_gtmp
1848: SET owning_party = inv_mwb_globals.g_owning_party;
1849: ELSE
1850: UPDATE mtl_mwb_gtmp
1851: SET owning_party = (SELECT vendor_name || '-' || vendor_site_code
1852: FROM po_vendor_sites_all ps, po_vendors pv
1853: WHERE pv.vendor_id = ps.vendor_id
1854: AND ps.vendor_site_id = rec.owning_organization_id)

Line 1870: UPDATE MTL_MWB_GTMP

1866: or (nvl(g_item_id,-9999) <> nvl(rec.item_id, -9999))
1867: or (nvl(g_org_id,-9999) <> nvl(rec.org_id, -9999))
1868: ) then
1869:
1870: UPDATE MTL_MWB_GTMP
1871: SET (
1872: ORIGINATION_TYPE
1873: , ORIGINATION_DATE
1874: , ACTION_DATE

Line 1907: UPDATE MTL_MWB_GTMP

1903: AND lot = rec.lot;
1904:
1905: -------------------------------------------------------
1906: -- Grade code and lot expiry information --------------
1907: UPDATE MTL_MWB_GTMP
1908: SET (
1909: GRADE_CODE
1910: , LOT_EXPIRY_DATE
1911: ) = (

Line 1940: UPDATE mtl_mwb_gtmp

1936: WHERE organization_id = rec.org_id
1937: AND inventory_item_id = rec.item_id;
1938:
1939: IF nvl(l_tracking_qty_ind, '@@@@') <> 'PS' THEN
1940: UPDATE mtl_mwb_gtmp
1941: SET SECONDARY_ONHAND = NULL
1942: , SECONDARY_UNPACKED = NULL
1943: , SECONDARY_PACKED = NULL
1944: , SECONDARY_UOM_CODE = NULL

Line 1957: UPDATE MTL_MWB_GTMP

1953:
1954: ----------------------------------------------------------------------------------------------
1955:
1956: IF inv_mwb_globals.g_lot_from = inv_mwb_globals.g_lot_to THEN
1957: UPDATE MTL_MWB_GTMP
1958: SET LOT = inv_mwb_globals.g_lot_from;
1959: END IF;
1960:
1961: IF inv_mwb_globals.g_serial_from = inv_mwb_globals.g_serial_to THEN

Line 1962: UPDATE MTL_MWB_GTMP

1958: SET LOT = inv_mwb_globals.g_lot_from;
1959: END IF;
1960:
1961: IF inv_mwb_globals.g_serial_from = inv_mwb_globals.g_serial_to THEN
1962: UPDATE MTL_MWB_GTMP
1963: SET SERIAL = inv_mwb_globals.g_serial_from;
1964: END IF;
1965:
1966: -- Onhand Material Status Support

Line 1987: UPDATE MTL_MWB_GTMP

1983: and serial_number = rec.SERIAL;
1984:
1985: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'serial status_id '||rec.status_id);
1986:
1987: UPDATE MTL_MWB_GTMP
1988: SET status_id = rec.status_id
1989: WHERE item_id = rec.item_id
1990: and serial = rec.SERIAL;
1991:

Line 2004: UPDATE MTL_MWB_GTMP

2000: WHERE status_id = rec.status_id;
2001:
2002: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'status code '||l_status_name);
2003:
2004: UPDATE MTL_MWB_GTMP
2005: SET status = l_status_name
2006: WHERE status_id = rec.status_id;
2007: END IF;
2008: END IF;