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 WSH_DELIVERY_DETAILS

Line 608: FROM wsh_delivery_details

604:
605: BEGIN
606: SELECT organization_id, inventory_item_id, picked_quantity, requested_quantity_uom
607: INTO l_organization_id, l_inventory_item_id, l_picked_quantity, l_requested_quantity_uom
608: FROM wsh_delivery_details
609: WHERE delivery_detail_id = p_delivery_detail_id;
610:
611: IF ( l_debug = 1 ) THEN
612: print_debug('got from WDD orgid='||l_organization_id||' itemid='||l_inventory_item_id||' pkdqty='||l_picked_quantity||' requom='||l_requested_quantity_uom, 4);

Line 795: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd

791:
792: CURSOR wdd_cur IS
793: SELECT wdd.delivery_detail_id, wdd.picked_quantity, wdd.requested_quantity_uom,
794: wdd.picked_quantity2, wdd.requested_quantity_uom2
795: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd
796: WHERE wda.parent_delivery_detail_id = p_parent_del_det_id
797: AND wdd.delivery_detail_id = wda.delivery_detail_id
798: AND wdd.organization_id = p_organization_id
799: AND wdd.inventory_item_id = p_inventory_item_id

Line 1039: -- LPN is in staging, Update WSH_DELIVERY_DETAILS

1035: END IF;
1036:
1037: IF ( p_record_source = 'WDD' OR p_record_source = 'wdd' ) THEN
1038: l_progress := '100';
1039: -- LPN is in staging, Update WSH_DELIVERY_DETAILS
1040: -- Need to retrieve the delviery_detail_id for the LPN, then pass to
1041: -- Other API from WDD processing
1042: BEGIN
1043: SELECT delivery_detail_id

Line 1045: FROM wsh_delivery_details

1041: -- Other API from WDD processing
1042: BEGIN
1043: SELECT delivery_detail_id
1044: INTO l_del_det_id
1045: FROM wsh_delivery_details
1046: WHERE organization_id = p_organization_id
1047: AND lpn_id = p_lpn_id
1048: AND released_status = 'X'; -- For LPN reuse ER : 6845650
1049: EXCEPTION

Line 1253: wsh_delivery_details wdd

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
1257: AND wdd.lpn_id = wlpn.lpn_id

Line 1263: wsh_delivery_details wdd,

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
1267: AND wdd.line_direction = 'O'

Line 1353: wsh_delivery_details wdd,

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
1357: AND wdd.line_direction = 'O'

Line 1636: wsh_delivery_details wddl,

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
1640: AND wddit.inventory_item_id = msi.inventory_item_id

Line 1638: wsh_delivery_details wddit

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
1640: AND wddit.inventory_item_id = msi.inventory_item_id
1641: AND msi.ont_pricing_qty_source = 'S'
1642: AND wddl.lpn_id = wlpn.lpn_id

Line 1801: FROM wsh_delivery_Details inner,

1797:
1798: ELSE
1799: OPEN x_lpn_lov FOR
1800: SELECT distinct outer.container_name, outer.lpn_id
1801: FROM wsh_delivery_Details inner,
1802: (SELECT wda.delivery_detail_id,
1803: wdd.inventory_item_id,
1804: wdd.lpn_id,wdd.container_name
1805: FROM wsh_delivery_details wdd,

Line 1805: FROM wsh_delivery_details wdd,

1801: FROM wsh_delivery_Details inner,
1802: (SELECT wda.delivery_detail_id,
1803: wdd.inventory_item_id,
1804: wdd.lpn_id,wdd.container_name
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

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 2115: FROM wsh_delivery_details wdd,

2111: AND msi.ont_pricing_qty_source = 'S'
2112: AND wdd1. picked_quantity2 is NULL
2113: AND wdd1.delivery_detail_id in
2114: (SELECT wda.delivery_detail_id
2115: FROM wsh_delivery_details wdd,
2116: wsh_delivery_assignments_v wda
2117: WHERE wdd.lpn_id= p_lpn_id
2118: AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650
2119: AND wdd.delivery_detail_id = wda.parent_delivery_detail_id

Line 2143: FROM wsh_delivery_details wdd,

2139: ) IS
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

Line 2153: wsh_delivery_details wdd1

2149: AND NVL(wdd.revision,'@@@') = NVL(NVL(p_from_item_revision,wdd.revision),'@@@')
2150: AND NVL(wdd.lot_number,'@@@') = NVL(p_from_item_lot_number,'@@@')
2151: AND wdd.delivery_detail_id in (SELECT wda.delivery_detail_id
2152: FROM wsh_delivery_assignments_v wda,
2153: wsh_delivery_details wdd1
2154: WHERE wdd1.lpn_id = in_lpn_id
2155: AND wdd1.released_status = 'X' -- For LPN reuse ER : 6845650
2156: AND wdd1.delivery_detail_id = wda.parent_delivery_Detail_id
2157: AND wdd1.organization_id = p_org_id);

Line 2300: FROM wsh_delivery_details wdd,

2296: NULL,
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

Line 2310: wsh_delivery_Details wdd1

2306: AND NVL(wdd.revision,'@@@') = NVL(p_from_item_revision,'@@@')
2307: AND NVL(wdd.lot_number,'@@@') = NVL(p_from_item_lot_number,'@@@')
2308: AND wdd.delivery_detail_id in (SELECT wda.delivery_detail_id
2309: FROM wsh_delivery_assignments_v wda,
2310: wsh_delivery_Details wdd1
2311: WHERE wdd1.lpn_id = p_from_lpn_id
2312: AND wdd1.released_status = 'X' -- For LPN reuse ER : 6845650
2313: AND wdd1.delivery_detail_id = wda.parent_delivery_Detail_id
2314: AND wdd1.organization_id = p_org_id)

Line 2453: FROM wsh_delivery_Details wdd,

2449: wdd.picked_quantity2,
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,