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 1442: FROM MTL_MWB_GTMP;

1438: ,OWNING_TP_TYPE
1439: ,PROJECT_ID
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:

Line 1518: UPDATE MTL_MWB_GTMP

1514: IF inv_mwb_globals.g_organization_code IS NOT NULL
1515: AND inv_mwb_globals.g_organization_id IS NOT NULL THEN
1516: --Bug 6834805
1517: if (nvl(g_org,'@@@@') <> inv_mwb_globals.g_organization_code) then
1518: UPDATE MTL_MWB_GTMP
1519: SET organization_code = inv_mwb_globals.g_organization_code;
1520:
1521: g_org := inv_mwb_globals.g_organization_code;
1522: end if;

Line 1532: UPDATE MTL_MWB_GTMP

1528: INTO l_to_org
1529: FROM mtl_parameters
1530: WHERE organization_id = rec.org_id;
1531:
1532: UPDATE MTL_MWB_GTMP
1533: SET organization_code = l_to_org
1534: , to_org = l_to_org
1535: WHERE org_id = rec.org_id;
1536:

Line 1545: UPDATE MTL_MWB_GTMP

1541:
1542: IF inv_mwb_globals.g_subinventory_code IS NOT NULL THEN
1543: --Bug 6834805
1544: if (nvl(g_sub,'@@@@') <> inv_mwb_globals.g_subinventory_code) then
1545: UPDATE MTL_MWB_GTMP
1546: SET SUBINVENTORY_CODE = inv_mwb_globals.g_subinventory_code;
1547:
1548: g_sub := inv_mwb_globals.g_subinventory_code;
1549: end if;

Line 1555: UPDATE MTL_MWB_GTMP

1551:
1552: IF rec.owning_org_id IS NOT NULL THEN
1553: --Bug 6834805
1554: if (nvl(g_own_org_id,-9999) <> rec.owning_org_id) then
1555: UPDATE MTL_MWB_GTMP
1556: SET owning_org = (SELECT organization_code
1557: FROM mtl_parameters
1558: WHERE organization_id = rec.owning_org_id)
1559: WHERE owning_org_id = rec.owning_org_id;

Line 1573: UPDATE MTL_MWB_GTMP

1569: INTO l_from_org_code
1570: FROM mtl_parameters
1571: WHERE organization_id = rec.from_org_id;
1572:
1573: UPDATE MTL_MWB_GTMP
1574: SET from_org = l_from_org_code
1575: WHERE from_org_id = rec.from_org_id;
1576: END IF;
1577: --to org

Line 1584: UPDATE MTL_MWB_GTMP

1580: INTO l_to_org_code
1581: FROM mtl_parameters
1582: WHERE organization_id = rec.to_org_id;
1583:
1584: UPDATE MTL_MWB_GTMP
1585: SET to_org = l_to_org_code
1586: WHERE to_org_id = rec.to_org_id;
1587: END IF;
1588: /* End of Bug 11716231. */

Line 1594: UPDATE MTL_MWB_GTMP

1590: ----------------- Update LPN ------------------------------------------
1591:
1592: IF rec.lpn_id IS NOT NULL THEN
1593: BEGIN
1594: UPDATE MTL_MWB_GTMP
1595: SET lpn = (SELECT license_plate_number
1596: FROM wms_license_plate_numbers
1597: WHERE lpn_id = rec.lpn_id)
1598: WHERE lpn_id = rec.lpn_id;

Line 1600: UPDATE MTL_MWB_GTMP

1596: FROM wms_license_plate_numbers
1597: WHERE lpn_id = rec.lpn_id)
1598: WHERE lpn_id = rec.lpn_id;
1599:
1600: UPDATE MTL_MWB_GTMP
1601: SET loaded = (SELECT 1
1602: FROM mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt
1603: WHERE wdt.status = 4
1604: AND wdt.task_type <> 2

Line 1613: UPDATE MTL_MWB_GTMP

1609: WHERE lpn_id = rec.lpn_id;
1610:
1611: EXCEPTION
1612: WHEN TOO_MANY_ROWS THEN
1613: UPDATE MTL_MWB_GTMP
1614: SET LOADED = 1
1615: WHERE lpn_id = rec.lpn_id;
1616: END;
1617: END IF;

Line 1625: UPDATE MTL_MWB_GTMP

1621: IF inv_mwb_globals.g_cost_group IS NOT NULL
1622: AND inv_mwb_globals.g_cost_group_id IS NOT NULL THEN
1623: --Bug 6834805
1624: if (nvl(g_cg,'@@@@') <> inv_mwb_globals.g_cost_group) then
1625: UPDATE MTL_MWB_GTMP
1626: SET cost_group = inv_mwb_globals.g_cost_group;
1627:
1628: g_cg := inv_mwb_globals.g_cost_group;
1629: end if;

Line 1634: UPDATE MTL_MWB_GTMP

1630: ELSE
1631: IF rec.cg_id IS NOT NULL THEN
1632: --Bug 6834805
1633: if (nvl(g_cg_id,-9999) <> rec.cg_id) then
1634: UPDATE MTL_MWB_GTMP
1635: SET cost_group = (SELECT distinct cost_group
1636: FROM cst_cost_groups
1637: WHERE cost_group_id = rec.cg_id)
1638: WHERE cg_id = rec.cg_id;

Line 1654: UPDATE MTL_MWB_GTMP

1650: -- Fix for Bug#8687440. Added secondary uom code in following update statement.
1651: if (nvl(g_item_id,-9999) <> rec.item_id
1652: or nvl(g_org_id,-9999) <> rec.org_id) then --Bug 12633111
1653:
1654: UPDATE MTL_MWB_GTMP
1655: SET (
1656: ITEM
1657: , ITEM_DESCRIPTION
1658: , PRIMARY_UOM_CODE

Line 1682: UPDATE MTL_MWB_GTMP

1678: IF inv_mwb_globals.g_locator_name IS NOT NULL
1679: AND inv_mwb_globals.g_locator_id IS NOT NULL THEN
1680: --Bug 6834805
1681: if (nvl(g_loc, '@@@@') <> inv_mwb_globals.g_locator_name) then
1682: UPDATE MTL_MWB_GTMP
1683: SET locator = substr(inv_mwb_globals.g_locator_name, 1, 100),--Bug6595049: truncating the locator to 100 chars
1684: locator_id = inv_mwb_globals.g_locator_id; -- Bug 7408480
1685:
1686: g_loc := inv_mwb_globals.g_locator_name;

Line 1694: UPDATE MTL_MWB_GTMP

1690: --Bug 6834805
1691: if (nvl(g_loc_id, -9999) <> rec.locator_id) then
1692:
1693: IF inv_mwb_globals.g_is_projects_enabled_org = 0 THEN
1694: UPDATE MTL_MWB_GTMP
1695: SET locator = substr((SELECT concatenated_segments
1696: FROM mtl_item_locations_kfv
1697: WHERE inventory_location_id = rec.locator_id and ORGANIZATION_ID = rec.org_id), 1, 100) -- Bug 6595049: truncating the locator to 100 chars. + Bug 15847437: Add ORGANIZATION_ID into where clause
1698: WHERE locator_id = rec.locator_id;

Line 1706: UPDATE MTL_MWB_GTMP

1702: /* Bug # 9288054 : Added extra condition in where clause "locator IS NULL" in below update
1703: to improve the performance. We should be upldating only those records
1704: which were not already updated for locator field. FP of bug 9209775 */
1705:
1706: UPDATE MTL_MWB_GTMP
1707: SET LOCATOR = substr(INV_PROJECT.GET_LOCATOR(REC.LOCATOR_ID, REC.ORG_ID), 1, 100) -- Bug 6595049: truncating the locator to 100 chars
1708: WHERE locator IS NULL AND
1709: locator_id = rec.locator_id;
1710:

Line 1720: --Earlier the project and task id's were never updated in the table MTL_MWB_GTMP

1716: WHERE inventory_location_id = rec.locator_id
1717: AND organization_id = rec.org_id;
1718:
1719: --BUG 8266074--
1720: --Earlier the project and task id's were never updated in the table MTL_MWB_GTMP
1721: --where as the project number was updated before.
1722: --BUG 8266074--
1723:
1724: --START BUG 8266074--

Line 1727: UPDATE MTL_MWB_GTMP

1723:
1724: --START BUG 8266074--
1725: /* Added project_name in following update statements for bug 13465952 */
1726: IF inv_mwb_globals.g_project_number IS NOT NULL THEN
1727: UPDATE MTL_MWB_GTMP
1728: SET project_number = inv_mwb_globals.g_project_number
1729: , (project_id, project_name)= (SELECT project_id, project_name
1730: FROM pjm_projects_all_ou_v --Bug 14751814,also display closed project
1731: WHERE project_number = inv_mwb_globals.g_project_number);

Line 1735: UPDATE MTL_MWB_GTMP

1731: WHERE project_number = inv_mwb_globals.g_project_number);
1732:
1733: ELSE
1734: IF l_project_id IS NOT NULL THEN
1735: UPDATE MTL_MWB_GTMP
1736: SET (project_number, project_name) = (SELECT project_number, project_name
1737: FROM pjm_projects_all_ou_v --Bug 14751814,also display closed project
1738: WHERE project_id = l_project_id) ,
1739: project_id = l_project_id

Line 1746: UPDATE MTL_MWB_GTMP

1742: END IF;
1743:
1744: IF inv_mwb_globals.g_task_number IS NOT NULL THEN
1745:
1746: UPDATE MTL_MWB_GTMP
1747: SET task_number = inv_mwb_globals.g_task_number,
1748: task_id = (SELECT task_id
1749: FROM pjm_tasks_v
1750: WHERE task_number = inv_mwb_globals.g_task_number

Line 1755: UPDATE MTL_MWB_GTMP

1751: AND project_number = inv_mwb_globals.g_project_number);
1752: ELSE
1753: -- BUG 8266074 Replacing rec.task_id by l_task_id --
1754: IF l_task_id IS NOT NULL THEN
1755: UPDATE MTL_MWB_GTMP
1756: SET task_number = (SELECT task_number
1757: FROM pjm_tasks_v
1758: WHERE task_id = l_task_id) ,
1759: task_id = l_task_id

Line 1781: UPDATE mtl_mwb_gtmp

1777: INTO l_shipment_num, l_shipped_date
1778: FROM rcv_shipment_headers rsh
1779: WHERE rsh.shipment_header_id = rec.shipment_header_id_asn;
1780:
1781: UPDATE mtl_mwb_gtmp
1782: SET document_number = l_shipment_num
1783: , shipped_date = l_shipped_date
1784: , document_type = l_mtl_location
1785: , document_type_id = 4

Line 1789: UPDATE mtl_mwb_gtmp

1785: , document_type_id = 4
1786: WHERE shipment_header_id_asn = rec.shipment_header_id_asn;
1787:
1788: IF rec.document_line_number IS NOT NULL THEN
1789: UPDATE mtl_mwb_gtmp
1790: SET document_line_number = (SELECT line_num
1791: FROM rcv_shipment_lines rsl
1792: WHERE rsl.shipment_line_id = rec.document_line_number)
1793: WHERE shipment_header_id_asn = rec.shipment_header_id_asn

Line 1798: UPDATE mtl_mwb_gtmp

1794: AND document_line_number = rec.document_line_number;
1795: END IF;
1796: ELSE -- PO
1797: l_mtl_location := document_type_meaning(1);
1798: UPDATE mtl_mwb_gtmp
1799: SET document_number = (SELECT segment1
1800: FROM po_headers_trx_v pha -- CLM project, bug 9403291
1801: WHERE pha.po_header_id = rec.po_header_id)
1802: , document_type = l_mtl_location

Line 1807: UPDATE mtl_mwb_gtmp

1803: , document_type_id = 1
1804: WHERE po_header_id = rec.po_header_id;
1805:
1806: IF rec.document_line_number IS NOT NULL THEN
1807: UPDATE mtl_mwb_gtmp
1808: SET document_line_number = (SELECT to_char(line_num)
1809: FROM po_lines_trx_v pla -- CLM project, bug 9403291
1810: WHERE pla.po_line_id = rec.document_line_number)
1811: WHERE po_header_id = rec.po_header_id

Line 1817: UPDATE mtl_mwb_gtmp

1813: END IF;
1814: END IF;
1815: ELSIF rec.req_header_id IS NOT NULL THEN -- Req
1816: l_mtl_location := document_type_meaning(2);
1817: UPDATE mtl_mwb_gtmp
1818: SET document_number = (SELECT segment1
1819: FROM po_req_headers_trx_v prha -- CLM project, bug 9403291
1820: WHERE prha.requisition_header_id = rec.req_header_id)
1821: , document_type = l_mtl_location

Line 1826: UPDATE mtl_mwb_gtmp

1822: , document_type_id = 2
1823: WHERE req_header_id = rec.req_header_id;
1824:
1825: IF rec.document_line_number IS NOT NULL THEN
1826: UPDATE mtl_mwb_gtmp
1827: SET document_line_number = (SELECT line_num
1828: FROM po_req_lines_trx_v prla -- CLM project, bug 9403291
1829: WHERE prla.requisition_line_id = rec.document_line_number)
1830: WHERE req_header_id = rec.req_header_id

Line 1836: UPDATE mtl_mwb_gtmp

1832: END IF;
1833: ELSIF rec.shipment_header_id_asn IS NOT NULL THEN -- Interorg
1834: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, rec.shipment_header_id_asn);
1835: l_mtl_location := document_type_meaning(3);
1836: UPDATE mtl_mwb_gtmp
1837: SET document_number = (SELECT shipment_num
1838: FROM rcv_shipment_headers rsh
1839: WHERE rsh.shipment_header_id = rec.shipment_header_id_asn)
1840: , document_type = l_mtl_location

Line 1845: UPDATE mtl_mwb_gtmp

1841: , document_type_id = 3
1842: WHERE shipment_header_id_asn = rec.shipment_header_id_asn;
1843:
1844: IF rec.document_line_number IS NOT NULL THEN
1845: UPDATE mtl_mwb_gtmp
1846: SET document_line_number = (SELECT line_num
1847: FROM rcv_shipment_lines rsl
1848: WHERE rsl.shipment_line_id = rec.document_line_number)
1849: WHERE shipment_header_id_asn = rec.shipment_header_id_asn

Line 1867: UPDATE mtl_mwb_gtmp

1863: , l_vendor_site_id
1864: FROM po_headers_all
1865: WHERE po_header_id = rec.po_header_id;
1866:
1867: UPDATE mtl_mwb_gtmp
1868: SET vendor_id = l_vendor_id
1869: , vendor_site_id = l_vendor_site_id
1870: WHERE po_header_id = rec.po_header_id;
1871: END IF;

Line 1875: UPDATE mtl_mwb_gtmp

1871: END IF;
1872:
1873: IF rec.vendor_id IS NOT NULL
1874: OR l_vendor_id IS NOT NULL THEN
1875: UPDATE mtl_mwb_gtmp
1876: SET trading_partner = (SELECT vendor_name
1877: FROM po_vendors
1878: WHERE vendor_id = l_vendor_id)
1879: WHERE vendor_id = l_vendor_id;

Line 1883: UPDATE mtl_mwb_gtmp

1879: WHERE vendor_id = l_vendor_id;
1880:
1881: IF rec.vendor_site_id IS NOT NULL
1882: OR l_vendor_site_id IS NOT NULL THEN
1883: UPDATE mtl_mwb_gtmp
1884: SET trading_partner_site = (SELECT vendor_site_code
1885: FROM po_vendor_sites_all
1886: WHERE vendor_site_id = l_vendor_site_id)
1887: WHERE vendor_id = l_vendor_id

Line 1903: UPDATE mtl_mwb_gtmp

1899: inv_mwb_globals.g_chk_inbound = 0 AND
1900: inv_mwb_globals.g_chk_onhand = 0
1901: ) OR inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
1902:
1903: UPDATE mtl_mwb_gtmp
1904: SET LPN_CONTEXT = lpn_context_meaning(3)
1905: WHERE lpn_id = rec.lpn_id;
1906: ELSE
1907: */

Line 1914: UPDATE mtl_mwb_gtmp

1910: INTO l_lpn_context_id
1911: FROM wms_license_plate_numbers
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)

Line 1924: UPDATE mtl_mwb_gtmp

1920: END IF;
1921: -- END IF;
1922:
1923: IF inv_mwb_globals.g_tree_doc_type_id = 4 THEN
1924: UPDATE mtl_mwb_gtmp
1925: SET document_type = document_type_meaning(4)
1926: , document_type_id = 4
1927: WHERE shipment_header_id_asn = rec.shipment_header_id_asn;
1928: END IF;

Line 1933: UPDATE mtl_mwb_gtmp

1929:
1930: IF rec.planning_tp_type = 1
1931: AND rec.planning_organization_id IS NOT NULL THEN
1932: IF inv_mwb_globals.g_planning_party IS NOT NULL THEN
1933: UPDATE mtl_mwb_gtmp
1934: SET planning_party = inv_mwb_globals.g_planning_party;
1935: ELSE
1936: UPDATE mtl_mwb_gtmp
1937: SET planning_party = (SELECT vendor_name || '-' || vendor_site_code

Line 1936: UPDATE mtl_mwb_gtmp

1932: IF inv_mwb_globals.g_planning_party IS NOT NULL THEN
1933: UPDATE mtl_mwb_gtmp
1934: SET planning_party = inv_mwb_globals.g_planning_party;
1935: ELSE
1936: UPDATE mtl_mwb_gtmp
1937: SET planning_party = (SELECT vendor_name || '-' || vendor_site_code
1938: FROM po_vendor_sites_all ps, po_vendors pv
1939: WHERE pv.vendor_id = ps.vendor_id
1940: AND ps.vendor_site_id = rec.planning_organization_id)

Line 1949: UPDATE mtl_mwb_gtmp

1945: IF rec.owning_tp_type = 1
1946: AND rec.owning_organization_id IS NOT NULL THEN
1947:
1948: IF inv_mwb_globals.g_owning_party IS NOT NULL THEN
1949: UPDATE mtl_mwb_gtmp
1950: SET owning_party = inv_mwb_globals.g_owning_party;
1951: ELSE
1952: UPDATE mtl_mwb_gtmp
1953: SET owning_party = (SELECT vendor_name || '-' || vendor_site_code

Line 1952: UPDATE mtl_mwb_gtmp

1948: IF inv_mwb_globals.g_owning_party IS NOT NULL THEN
1949: UPDATE mtl_mwb_gtmp
1950: SET owning_party = inv_mwb_globals.g_owning_party;
1951: ELSE
1952: UPDATE mtl_mwb_gtmp
1953: SET owning_party = (SELECT vendor_name || '-' || vendor_site_code
1954: FROM po_vendor_sites_all ps, po_vendors pv
1955: WHERE pv.vendor_id = ps.vendor_id
1956: AND ps.vendor_site_id = rec.owning_organization_id)

Line 1973: UPDATE MTL_MWB_GTMP

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
1976: , ORIGINATION_DATE
1977: , ACTION_DATE

Line 2011: UPDATE MTL_MWB_GTMP

2007: /* End of Bug 8396954 */
2008:
2009: -------------------------------------------------------
2010: -- Grade code and lot expiry information --------------
2011: UPDATE MTL_MWB_GTMP
2012: SET (
2013: GRADE_CODE
2014: , LOT_EXPIRY_DATE
2015: ) = (

Line 2044: UPDATE mtl_mwb_gtmp

2040: WHERE organization_id = rec.org_id
2041: AND inventory_item_id = rec.item_id;
2042:
2043: IF nvl(l_tracking_qty_ind, '@@@@') <> 'PS' THEN
2044: UPDATE mtl_mwb_gtmp
2045: SET SECONDARY_ONHAND = NULL
2046: , SECONDARY_UNPACKED = NULL
2047: , SECONDARY_PACKED = NULL
2048: , SECONDARY_UOM_CODE = NULL

Line 2061: UPDATE MTL_MWB_GTMP

2057:
2058: ----------------------------------------------------------------------------------------------
2059:
2060: IF inv_mwb_globals.g_lot_from = inv_mwb_globals.g_lot_to THEN
2061: UPDATE MTL_MWB_GTMP
2062: SET LOT = inv_mwb_globals.g_lot_from;
2063: END IF;
2064:
2065: IF inv_mwb_globals.g_serial_from = inv_mwb_globals.g_serial_to THEN

Line 2066: UPDATE MTL_MWB_GTMP

2062: SET LOT = inv_mwb_globals.g_lot_from;
2063: END IF;
2064:
2065: IF inv_mwb_globals.g_serial_from = inv_mwb_globals.g_serial_to THEN
2066: UPDATE MTL_MWB_GTMP
2067: SET SERIAL = inv_mwb_globals.g_serial_from;
2068: END IF;
2069:
2070: -- Onhand Material Status Support

Line 2091: UPDATE MTL_MWB_GTMP

2087: and serial_number = rec.SERIAL;
2088:
2089: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'serial status_id '||rec.status_id);
2090:
2091: UPDATE MTL_MWB_GTMP
2092: SET status_id = rec.status_id
2093: WHERE item_id = rec.item_id
2094: and serial = rec.SERIAL;
2095:

Line 2108: UPDATE MTL_MWB_GTMP

2104: WHERE status_id = rec.status_id;
2105:
2106: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'status code '||l_status_name);
2107:
2108: UPDATE MTL_MWB_GTMP
2109: SET status = l_status_name
2110: WHERE status_id = rec.status_id;
2111: END IF;
2112: END IF;

Line 2261: update mtl_mwb_gtmp

2257: --Bug 13606923
2258: if (rec.lpn_id is not null) then
2259: if(rec.serial is not null and l_serial_loaded = 1) then
2260:
2261: update mtl_mwb_gtmp
2262: set onhand = (onhand - onhand),
2263: unpacked = (unpacked - unpacked),
2264: packed = (packed - packed),
2265: loaded_quantity = 0

Line 2268: update mtl_mwb_gtmp

2264: packed = (packed - packed),
2265: loaded_quantity = 0
2266: where rowid = rec.rowid;
2267: elsif (rec.serial is null) then
2268: update mtl_mwb_gtmp
2269: set onhand = (onhand - packed_loaded_qty - unpacked_loaded_qty),
2270: unpacked = (unpacked - unpacked_loaded_qty),
2271: packed = (packed - packed_loaded_qty),
2272: loaded_quantity = 0

Line 2277: update mtl_mwb_gtmp

2273: where rowid = rec.rowid;
2274: end if;
2275: else
2276: if(rec.serial is not null and l_serial_loaded = 1) then
2277: update mtl_mwb_gtmp
2278: set loaded_quantity = 1
2279: where rowid = rec.rowid;
2280: elsif (rec.serial is null) then
2281: update mtl_mwb_gtmp

Line 2281: update mtl_mwb_gtmp

2277: update mtl_mwb_gtmp
2278: set loaded_quantity = 1
2279: where rowid = rec.rowid;
2280: elsif (rec.serial is null) then
2281: update mtl_mwb_gtmp
2282: set loaded_quantity = (packed_loaded_qty + unpacked_loaded_qty)
2283: where rowid = rec.rowid;
2284: end if;
2285: end if;

Line 2287: update mtl_mwb_gtmp

2283: where rowid = rec.rowid;
2284: end if;
2285: end if;
2286: ELSE -- non-wms enabled org
2287: update mtl_mwb_gtmp
2288: set loaded_quantity = 0
2289: where rowid = rec.rowid;
2290:
2291: END IF;