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 MTL_SYSTEM_ITEMS

Line 94: FROM MTL_SYSTEM_ITEMS

90: x_secondary_default_ind,
91: x_secondary_uom_code,
92: x_uom_deviation_high,
93: x_uom_deviation_low
94: FROM MTL_SYSTEM_ITEMS
95: WHERE organization_id = p_organization_id
96: AND inventory_item_id = p_inventory_item_id;
97:
98: l_progress := '300';

Line 209: FROM MTL_SYSTEM_ITEMS

205:
206: IF ( l_wms_org_flag ) THEN
207: SELECT NVL(ont_pricing_qty_source, G_PRICE_PRIMARY)
208: INTO l_ont_pricing_qty_source
209: FROM MTL_SYSTEM_ITEMS
210: WHERE organization_id = p_organization_id
211: AND inventory_item_id = p_inventory_item_id;
212: ELSE -- not a wms org
213: IF ( l_debug = 1 ) THEN

Line 313: FROM mtl_system_items

309: INTO x_ont_pricing_qty_source,
310: l_default_ind,
311: l_uom_code,
312: x_secondary_uom_code
313: FROM mtl_system_items
314: WHERE organization_id = p_organization_id
315: AND inventory_item_id = p_inventory_item_id;
316: ELSE -- not a wms org
317: IF ( l_debug = 1 ) THEN

Line 1262: FROM mtl_system_items msi,

1258: AND wdd.released_status = 'X'; -- For LPN reuse ER : 6845650
1259:
1260: CURSOR wdd_item_cur (p_parent_delivery_detail_id NUMBER) IS
1261: SELECT distinct wdd.organization_id, wdd.inventory_item_id, msi.primary_uom_code, msi.secondary_uom_code
1262: FROM mtl_system_items msi,
1263: wsh_delivery_details wdd,
1264: wsh_delivery_assignments_v wda
1265: WHERE wda.parent_delivery_detail_id = p_parent_delivery_detail_id
1266: AND wdd.delivery_detail_id = wda.delivery_detail_id

Line 1352: FROM mtl_system_items msi,

1348: BEGIN
1349: SELECT 1 INTO l_temp FROM DUAL
1350: WHERE EXISTS (
1351: SELECT 1
1352: FROM mtl_system_items msi,
1353: wsh_delivery_details wdd,
1354: wsh_delivery_assignments_v wda
1355: WHERE wda.parent_delivery_detail_id = wdd_nested_lpn_rec.delivery_detail_id
1356: AND wdd.delivery_detail_id = wda.delivery_detail_id

Line 1424: FROM mtl_system_items

1420: BEGIN
1421: SELECT ont_pricing_qty_source, secondary_default_ind, primary_uom_code,
1422: secondary_uom_code, lot_control_code
1423: INTO l_pricing_ind, l_default_ind, l_pri_uom, l_sec_uom, l_lot_control_code
1424: FROM mtl_system_items
1425: WHERE organization_id = mmtt_item_rec.organization_id
1426: AND inventory_item_id = mmtt_item_rec.inventory_item_id;
1427: EXCEPTION
1428: WHEN NO_DATA_FOUND THEN

Line 1583: FROM wms_lpn_contents wlc , mtl_system_items_b msi

1579: AND wlpn.organization_id = p_org_id
1580: AND wlpn.license_plate_number LIKE (p_lpn || '%')
1581: AND EXISTS (
1582: SELECT msi.inventory_item_id
1583: FROM wms_lpn_contents wlc , mtl_system_items_b msi
1584: WHERE wlc.organization_id = msi.organization_id
1585: AND wlc.inventory_item_id = msi.inventory_item_id
1586: AND msi.ont_pricing_qty_source = 'S'
1587: AND msi.organization_id = p_org_id

Line 1595: mtl_system_items_b msi

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
1599: AND wlpn.lpn_id = nvl(mmtt.transfer_lpn_id, content_lpn_id)

Line 1610: mtl_system_items_b msi

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
1614: AND wlpn.lpn_id = mmtt.transfer_lpn_id

Line 1635: FROM mtl_system_items_b msi,

1631: AND wlpn.organization_id = p_org_id
1632: AND wlpn.license_plate_number LIKE (p_lpn || '%')
1633: AND EXISTS (
1634: SELECT msi.inventory_item_id, wddl.lpn_id
1635: FROM mtl_system_items_b msi,
1636: wsh_delivery_details wddl,
1637: wsh_delivery_assignments_v wda,
1638: wsh_delivery_details wddit
1639: WHERE wddit.organization_id = msi.organization_id

Line 1653: mtl_system_items_b msi, mtl_transaction_lots_temp mtlt

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
1657: AND msi.ont_pricing_qty_source = 'S'

Line 1670: mtl_system_items_b msi,

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
1674: AND mmtt.organization_id = p_org_id

Line 1711: FROM mtl_system_items_b msi, wms_lpn_contents wlc

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
1712: WHERE wlc.organization_id = wlpn.organization_id
1713: AND wlc.parent_lpn_id = wlpn.lpn_id
1714: AND msi.organization_id = wlc.organization_id
1715: AND msi.inventory_item_id = wlc.inventory_item_id

Line 1732: FROM wms_lpn_contents wlc , mtl_system_items_b msi

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
1732: FROM wms_lpn_contents wlc , mtl_system_items_b msi
1733: WHERE wlc.organization_id = msi.organization_id
1734: AND wlc.inventory_item_id = msi.inventory_item_id
1735: AND msi.ont_pricing_qty_source = 'S'
1736: AND wlc.parent_lpn_id = wlpn.lpn_id)

Line 1739: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt,

1735: AND msi.ont_pricing_qty_source = 'S'
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

Line 1752: FROM mtl_system_items msi,

1748: AND wlpn.license_plate_number LIKE (p_inner_lpn || '%');
1749: /*UNION
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)

Line 1768: FROM mtl_system_items msi

1764: ELSE
1765: IF (p_lpn_context = 8 OR p_lpn_context = 1) THEN --Packing
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

Line 1784: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt

1780: AND mtlt.secondary_quantity IS NULL
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

Line 1819: FROM mtl_system_items_b msi

1815: AND picked_quantity2 is null) outer
1816: WHERE inner.delivery_detail_id = outer.delivery_Detail_id
1817: AND outer.container_name LIKE (p_inner_lpn || '%')
1818: AND exists (SELECT msi.inventory_item_id
1819: FROM mtl_system_items_b msi
1820: WHERE msi.organization_id = inner.organization_id
1821: AND msi.organization_id = p_org_id
1822: AND msi.ont_pricing_qty_source = 'S'
1823: AND msi.inventory_item_id = inner.inventory_item_id);

Line 1885: FROM mtl_system_items_kfv msiv,

1881: , NVL(msi.SECONDARY_DEFAULT_IND,'')
1882: , NVL(msi.TRACKING_QUANTITY_IND,'P')
1883: , NVL(msi.DUAL_UOM_DEVIATION_HIGH,0)
1884: , NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
1885: FROM mtl_system_items_kfv msiv,
1886: wms_lpn_contents wlc,
1887: mtl_system_items msi
1888: WHERE wlc.parent_lpn_id = p_lpn_id
1889: AND wlc.organization_id = p_org_id

Line 1887: mtl_system_items msi

1883: , NVL(msi.DUAL_UOM_DEVIATION_HIGH,0)
1884: , NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
1885: FROM mtl_system_items_kfv msiv,
1886: wms_lpn_contents wlc,
1887: mtl_system_items msi
1888: WHERE wlc.parent_lpn_id = p_lpn_id
1889: AND wlc.organization_id = p_org_id
1890: AND msi.organization_id = wlc.organization_id
1891: AND msi.inventory_item_id = wlc.inventory_item_id

Line 1948: FROM mtl_system_items_kfv msi, wms_lpn_contents wlc

1944: , NVL(msi.SECONDARY_DEFAULT_IND,'')
1945: , NVL(msi.TRACKING_QUANTITY_IND,'P')
1946: , NVL(msi.DUAL_UOM_DEVIATION_HIGH,0)
1947: , NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
1948: FROM mtl_system_items_kfv msi, wms_lpn_contents wlc
1949: WHERE wlc.parent_lpn_id = p_lpn_id
1950: AND wlc.inventory_item_id = msi.inventory_item_id
1951: AND msi.ont_pricing_qty_source = 'S'
1952: AND wlc.organization_id = msi.organization_id

Line 1998: FROM mtl_system_items_kfv msi, mtl_material_transactions_temp mmtt

1994: , NVL(msi.SECONDARY_DEFAULT_IND,'')
1995: , NVL(msi.TRACKING_QUANTITY_IND,'P')
1996: , NVL(msi.DUAL_UOM_DEVIATION_HIGH,0)
1997: , NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
1998: FROM mtl_system_items_kfv msi, mtl_material_transactions_temp mmtt
1999: WHERE (mmtt.content_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id = p_lpn_id)
2000: AND mmtt.organization_id = p_org_id
2001: AND mmtt.organization_id = msi.organization_id
2002: AND msi.ont_pricing_qty_source = 'S'

Line 2054: from mtl_system_items_kfv msi, mtl_material_transactions_temp mmtt

2050: , NVL(msi.SECONDARY_DEFAULT_IND,'')
2051: , NVL(msi.TRACKING_QUANTITY_IND,'P')
2052: , NVL(msi.DUAL_UOM_DEVIATION_HIGH,0)
2053: , NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
2054: from mtl_system_items_kfv msi, mtl_material_transactions_temp mmtt
2055: where (mmtt.content_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id = p_lpn_id)
2056: and mmtt.organization_id = p_org_id
2057: and mmtt.organization_id = msi.organization_id
2058: and mmtt.inventory_item_id = msi.inventory_item_id

Line 2108: FROM mtl_system_items_kfv msi, wsh_Delivery_Details wdd1

2104: , NVL(msi.SECONDARY_DEFAULT_IND,'')
2105: , NVL(msi.TRACKING_QUANTITY_IND,'P')
2106: , NVL(msi.DUAL_UOM_DEVIATION_HIGH,0)
2107: , NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
2108: FROM mtl_system_items_kfv msi, wsh_Delivery_Details wdd1
2109: WHERE wdd1.inventory_item_id = msi.inventory_item_id
2110: AND wdd1.organization_id = msi.organization_id
2111: AND msi.ont_pricing_qty_source = 'S'
2112: AND wdd1. picked_quantity2 is NULL

Line 2144: mtl_system_items_b msib

2140:
2141: CURSOR itemCur(in_lpn_id NUMBER) IS
2142: SELECT picked_quantity2
2143: FROM wsh_delivery_details wdd,
2144: mtl_system_items_b msib
2145: WHERE wdd.inventory_item_id = p_from_item_id
2146: AND wdd.inventory_item_id = msib.inventory_item_id
2147: AND wdd.organization_id = p_org_id
2148: AND wdd.organization_id = msib.organization_id

Line 2301: mtl_system_items_b msib

2297: NULL)) requested_quantity,
2298: sum(picked_quantity2) picked_quantity2,
2299: msib.primary_uom_code
2300: FROM wsh_delivery_details wdd,
2301: mtl_system_items_b msib
2302: WHERE wdd.inventory_item_id = p_from_item_id
2303: AND wdd.inventory_item_id = msib.inventory_item_id
2304: AND wdd.organization_id = p_org_id
2305: AND wdd.organization_id = msib.organization_id

Line 2454: mtl_system_items msi

2450: msi.primary_uom_code,
2451: msi.secondary_uom_code,
2452: msi.secondary_default_ind
2453: FROM wsh_delivery_Details wdd,
2454: mtl_system_items msi
2455: WHERE wdd.delivery_detail_id in
2456: (SELECT wda.delivery_detail_id
2457: FROM wsh_delivery_assignments_v wda,
2458: wsh_new_deliveries wnd