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.WMS_CATCH_WEIGHT_PVT dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 1252: FROM wms_license_plate_numbers wlpn,

1248: l_progress VARCHAR2(10) := '0';
1249:
1250: CURSOR wdd_nested_lpn_cur IS
1251: SELECT wlpn.lpn_id, wdd.delivery_detail_id
1252: FROM wms_license_plate_numbers wlpn,
1253: wsh_delivery_details wdd
1254: WHERE wlpn.organization_id = p_organization_id
1255: AND wlpn.outermost_lpn_id = p_outermost_lpn_id
1256: AND wdd.organization_id = wlpn.organization_id

Line 1322: FROM wms_license_plate_numbers

1318:
1319: BEGIN
1320: SELECT lpn_context
1321: INTO l_lpn_context
1322: FROM wms_license_plate_numbers
1323: WHERE organization_id = p_organization_id
1324: AND lpn_id = p_outermost_lpn_id;
1325: EXCEPTION
1326: WHEN NO_DATA_FOUND THEN

Line 1576: FROM wms_license_plate_numbers wlpn, wms_license_plate_numbers wlpn2

1572: IF (UPPER(p_entry_type) = 'CT_WT_ALL') THEN
1573: OPEN x_lpn_lov FOR
1574: SELECT UNIQUE wlpn2.license_plate_number,
1575: wlpn.outermost_lpn_id outer_lpn_id, wlpn.lpn_context
1576: FROM wms_license_plate_numbers wlpn, wms_license_plate_numbers wlpn2
1577: WHERE wlpn.outermost_lpn_id = wlpn2.lpn_id
1578: AND wlpn.lpn_context in (11,8) -- picked/loaded
1579: AND wlpn.organization_id = p_org_id
1580: AND wlpn.license_plate_number LIKE (p_lpn || '%')

Line 1594: wms_license_plate_numbers wlpn,

1590: SELECT UNIQUE wlpn.license_plate_number,
1591: nvl(mmtt.transfer_lpn_id,mmtt.content_lpn_id) outer_lpn,
1592: wlpn.lpn_context
1593: FROM mtl_material_transactions_temp mmtt,
1594: wms_license_plate_numbers wlpn,
1595: mtl_system_items_b msi
1596: WHERE mmtt.inventory_item_id = msi.inventory_item_id
1597: AND mmtt.organization_id = msi.organization_id
1598: AND mmtt.organization_id = p_org_id

Line 1609: wms_license_plate_numbers wlpn,

1605: SELECT UNIQUE wlpn.license_plate_number,
1606: transfer_lpn_id,
1607: wlpn.lpn_context
1608: FROM mtl_material_transactions_temp mmtt,
1609: wms_license_plate_numbers wlpn,
1610: mtl_system_items_b msi
1611: WHERE mmtt.inventory_item_id = msi.inventory_item_id
1612: AND mmtt.organization_id = msi.organization_id
1613: AND mmtt.organization_id = p_org_id

Line 1617: FROM wms_license_plate_numbers wlpn2

1613: AND mmtt.organization_id = p_org_id
1614: AND wlpn.lpn_id = mmtt.transfer_lpn_id
1615: AND mmtt.transfer_lpn_id IS NOT NULL
1616: AND EXISTS (SELECT wlpn2.lpn_id
1617: FROM wms_license_plate_numbers wlpn2
1618: WHERE wlpn2.lpn_id = mmtt.content_lpn_id
1619: AND wlpn2.lpn_context = 8)
1620: AND msi.ont_pricing_qty_source = 'S'
1621: AND wlpn.license_plate_number LIKE (p_lpn || '%')

Line 1628: FROM wms_license_plate_numbers wlpn, wms_license_plate_numbers wlpn2

1624: ELSE
1625: OPEN x_lpn_lov FOR
1626: SELECT UNIQUE wlpn2.license_plate_number,wlpn.outermost_lpn_id,
1627: wlpn2.lpn_context
1628: FROM wms_license_plate_numbers wlpn, wms_license_plate_numbers wlpn2
1629: WHERE wlpn.outermost_lpn_id = wlpn2.lpn_id
1630: AND wlpn.lpn_context in (11) -- picked
1631: AND wlpn.organization_id = p_org_id
1632: AND wlpn.license_plate_number LIKE (p_lpn || '%')

Line 1652: FROM mtl_material_transactions_temp mmtt, wms_license_plate_numbers wlpn,

1648: UNION
1649: SELECT UNIQUE wlpn.license_plate_number,
1650: nvl(mmtt.transfer_lpn_id,mmtt.content_lpn_id) outer_lpn,
1651: wlpn.lpn_context
1652: FROM mtl_material_transactions_temp mmtt, wms_license_plate_numbers wlpn,
1653: mtl_system_items_b msi, mtl_transaction_lots_temp mtlt
1654: WHERE mmtt.inventory_item_id = msi.inventory_item_id
1655: AND mmtt.organization_id = msi.organization_id
1656: AND mmtt.organization_id = p_org_id

Line 1669: wms_license_plate_numbers wlpn,

1665: UNION
1666: SELECT UNIQUE wlpn.license_plate_number,
1667: transfer_lpn_id, wlpn.lpn_context
1668: FROM mtl_material_transactions_temp mmtt,
1669: wms_license_plate_numbers wlpn,
1670: mtl_system_items_b msi,
1671: mtl_transaction_lots_temp mtlt
1672: WHERE mmtt.inventory_item_id = msi.inventory_item_id
1673: AND mmtt.organization_id = msi.organization_id

Line 1679: FROM wms_license_plate_numbers wlpn2

1675: AND wlpn.lpn_id = mmtt.transfer_lpn_id
1676: AND wlpn.license_plate_number LIKE (p_lpn || '%')
1677: AND mmtt.transfer_lpn_id IS NOT NULL
1678: AND EXISTS (SELECT wlpn2.lpn_id
1679: FROM wms_license_plate_numbers wlpn2
1680: WHERE wlpn2.lpn_id = mmtt.content_lpn_id
1681: AND wlpn2.lpn_context = 8)
1682: AND mmtt.secondary_transaction_quantity is null -- catch.wt not enterd
1683: AND msi.ont_pricing_qty_source = 'S'

Line 1707: FROM wms_license_plate_numbers wlpn

1703: OPEN x_lpn_lov FOR
1704: SELECT owlpn.license_plate_number, owlpn.lpn_id
1705: FROM (
1706: SELECT wlpn.license_plate_number, wlpn.lpn_id
1707: FROM wms_license_plate_numbers wlpn
1708: WHERE outermost_lpn_id = p_outer_lpn_id
1709: AND EXISTS (
1710: SELECT 1
1711: FROM mtl_system_items_b msi, wms_lpn_contents wlc

Line 1727: FROM wms_license_plate_numbers wlpn

1723: ELSIF (UPPER(p_entry_type) = 'CT_WT_ALL') THEN
1724:
1725: OPEN x_lpn_lov FOR
1726: SELECT distinct wlpn.license_plate_number, lpn_id
1727: FROM wms_license_plate_numbers wlpn
1728: WHERE outermost_lpn_id = p_outer_lpn_id
1729: AND wlpn.license_plate_number LIKE (p_inner_lpn || '%')
1730: AND EXISTS (
1731: SELECT msi.inventory_item_id

Line 1740: wms_license_plate_numbers wlpn

1736: AND wlc.parent_lpn_id = wlpn.lpn_id)
1737: UNION
1738: SELECT distinct license_plate_number, content_lpn_id
1739: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt,
1740: wms_license_plate_numbers wlpn
1741: WHERE (mmtt.content_lpn_id = p_outer_lpn_id
1742: OR mmtt.transfer_lpn_id = p_outer_lpn_id )
1743: AND mmtt.organization_id = p_org_id
1744: AND mmtt.organization_id = msi.organization_id

Line 1754: wms_license_plate_numbers wlpn

1750: SELECT distinct license_plate_number,
1751: transfer_lpn_id
1752: FROM mtl_system_items msi,
1753: mtl_material_transactions_temp mmtt,
1754: wms_license_plate_numbers wlpn
1755: WHERE (mmtt.content_lpn_id = p_outer_lpn_id
1756: OR mmtt.transfer_lpn_id = p_outer_lpn_id)
1757: AND mmtt.organization_id = p_org_id
1758: AND mmtt.organization_id = msi.organization_id

Line 1770: ,wms_license_plate_numbers wlpn

1766: OPEN x_lpn_lov FOR
1767: SELECT distinct wlpn.license_plate_number, content_lpn_id
1768: FROM mtl_system_items msi
1769: ,mtl_material_transactions_temp mmtt
1770: ,wms_license_plate_numbers wlpn
1771: ,mtl_transaction_lots_temp mtlt
1772: WHERE mmtt.content_lpn_id = p_outer_lpn_id
1773: AND mmtt.organization_id = p_org_id
1774: AND mmtt.organization_id = msi.organization_id

Line 1785: ,wms_license_plate_numbers wlpn

1781: AND wlpn.license_plate_number LIKE (p_inner_lpn || '%')
1782: UNION
1783: SELECT distinct wlpn.license_plate_number, content_lpn_id
1784: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt
1785: ,wms_license_plate_numbers wlpn
1786: ,mtl_transaction_lots_temp mtlt
1787: WHERE mmtt.transfer_lpn_id = p_outer_lpn_id
1788: AND mmtt.organization_id = p_org_id
1789: AND mmtt.organization_id = msi.organization_id

Line 1809: FROM wms_license_plate_numbers wlpn

1805: FROM wsh_delivery_details wdd,
1806: wsh_delivery_assignments_v wda
1807: WHERE wdd.lpn_id in (
1808: SELECT wlpn.lpn_id
1809: FROM wms_license_plate_numbers wlpn
1810: WHERE outermost_lpn_id = p_outer_lpn_id)
1811: AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650
1812: AND wda.parent_delivery_detail_id = wdd.delivery_detail_id
1813: AND wdd.organization_id = p_org_id