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 622: FROM wsh_delivery_details

618:
619: BEGIN
620: SELECT organization_id, inventory_item_id, picked_quantity, requested_quantity_uom
621: INTO l_organization_id, l_inventory_item_id, l_picked_quantity, l_requested_quantity_uom
622: FROM wsh_delivery_details
623: WHERE delivery_detail_id = p_delivery_detail_id;
624:
625: IF ( l_debug = 1 ) THEN
626: 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 809: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd

805:
806: CURSOR wdd_cur IS
807: SELECT wdd.delivery_detail_id, wdd.picked_quantity, wdd.requested_quantity_uom,
808: wdd.picked_quantity2, wdd.requested_quantity_uom2
809: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd
810: WHERE wda.parent_delivery_detail_id = p_parent_del_det_id
811: AND wdd.delivery_detail_id = wda.delivery_detail_id
812: AND wdd.organization_id = p_organization_id
813: AND wdd.inventory_item_id = p_inventory_item_id

Line 1377: , wsh_delivery_details wdd1

1373: )
1374: ) primary_picked_qty
1375: , wdd2.requested_quantity_uom
1376: FROM wms_license_plate_numbers wlpn
1377: , wsh_delivery_details wdd1
1378: , wsh_delivery_assignments_v wda
1379: , wsh_delivery_details wdd2
1380: , mtl_system_items msi
1381: WHERE wlpn.lpn_id = p_lpn_id

Line 1379: , wsh_delivery_details wdd2

1375: , wdd2.requested_quantity_uom
1376: FROM wms_license_plate_numbers wlpn
1377: , wsh_delivery_details wdd1
1378: , wsh_delivery_assignments_v wda
1379: , wsh_delivery_details wdd2
1380: , mtl_system_items msi
1381: WHERE wlpn.lpn_id = p_lpn_id
1382: AND wlpn.lpn_context = 11
1383: AND wdd1.organization_id = p_organization_id

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

3366: END IF;
3367:
3368: IF ( p_record_source = 'WDD' OR p_record_source = 'wdd' ) THEN
3369: l_progress := '100';
3370: -- LPN is in staging, Update WSH_DELIVERY_DETAILS
3371: -- Need to retrieve the delviery_detail_id for the LPN, then pass to
3372: -- Other API from WDD processing
3373: BEGIN
3374: SELECT delivery_detail_id

Line 3376: FROM wsh_delivery_details

3372: -- Other API from WDD processing
3373: BEGIN
3374: SELECT delivery_detail_id
3375: INTO l_del_det_id
3376: FROM wsh_delivery_details
3377: WHERE organization_id = p_organization_id
3378: AND lpn_id = p_lpn_id
3379: AND released_status = 'X'; -- For LPN reuse ER : 6845650
3380: EXCEPTION

Line 3584: wsh_delivery_details wdd

3580:
3581: CURSOR wdd_nested_lpn_cur IS
3582: SELECT wlpn.lpn_id, wdd.delivery_detail_id
3583: FROM wms_license_plate_numbers wlpn,
3584: wsh_delivery_details wdd
3585: WHERE wlpn.organization_id = p_organization_id
3586: AND wlpn.outermost_lpn_id = p_outermost_lpn_id
3587: AND wdd.organization_id = wlpn.organization_id
3588: AND wdd.lpn_id = wlpn.lpn_id

Line 3594: wsh_delivery_details wdd,

3590:
3591: CURSOR wdd_item_cur (p_parent_delivery_detail_id NUMBER) IS
3592: SELECT distinct wdd.organization_id, wdd.inventory_item_id, msi.primary_uom_code, msi.secondary_uom_code
3593: FROM mtl_system_items msi,
3594: wsh_delivery_details wdd,
3595: wsh_delivery_assignments_v wda
3596: WHERE wda.parent_delivery_detail_id = p_parent_delivery_detail_id
3597: AND wdd.delivery_detail_id = wda.delivery_detail_id
3598: AND wdd.line_direction = 'O'

Line 3684: wsh_delivery_details wdd,

3680: SELECT 1 INTO l_temp FROM DUAL
3681: WHERE EXISTS (
3682: SELECT 1
3683: FROM mtl_system_items msi,
3684: wsh_delivery_details wdd,
3685: wsh_delivery_assignments_v wda
3686: WHERE wda.parent_delivery_detail_id = wdd_nested_lpn_rec.delivery_detail_id
3687: AND wdd.delivery_detail_id = wda.delivery_detail_id
3688: AND wdd.line_direction = 'O'

Line 3949: FROM wsh_delivery_details wdd,

3945: ) RETURN VARCHAR2 IS
3946:
3947: CURSOR c_get_all_wdd (p_lpn_wdd_id IN NUMBER) IS
3948: SELECT 'x'
3949: FROM wsh_delivery_details wdd,
3950: mtl_system_items msi
3951: WHERE wdd.delivery_detail_id IN (SELECT delivery_detail_id
3952: FROM wsh_delivery_assignments wda
3953: START WITH parent_delivery_detail_id = p_lpn_wdd_id

Line 3965: FROM wsh_delivery_details wdd

3961: );
3962:
3963: CURSOR c_get_wdd_to_upd (p_lpn_wdd_id IN NUMBER) IS
3964: SELECT 'x'
3965: FROM wsh_delivery_details wdd
3966: WHERE wdd.delivery_detail_id IN (SELECT delivery_detail_id
3967: FROM wsh_delivery_assignments wda
3968: WHERE parent_delivery_detail_id IN
3969: ( SELECT parent_delivery_detail_id

Line 3974: FROM wsh_delivery_details wdd2,

3970: FROM wsh_delivery_assignments wda2
3971: START WITH wda2.parent_delivery_detail_id = p_lpn_wdd_id
3972: CONNECT BY PRIOR wda2.delivery_detail_id = wda2.parent_delivery_detail_id)
3973: AND EXISTS (SELECT 1
3974: FROM wsh_delivery_details wdd2,
3975: wms_license_plate_numbers wlpn
3976: WHERE wdd2.delivery_detail_id = wda.parent_delivery_detail_id
3977: AND wdd2.lpn_id = wlpn.lpn_id
3978: AND NVL(wlpn.CATCH_WEIGHT_FLAG,'N') = 'N') )

Line 3999: FROM wsh_delivery_details

3995: l_ret_val := 'N';
3996:
3997: SELECT delivery_detail_id
3998: INTO l_lpn_wdd_id
3999: FROM wsh_delivery_details
4000: WHERE lpn_id = p_lpn_id
4001: AND organization_id = p_organization_id
4002: AND released_status = 'X';
4003:

Line 4642: FROM wsh_delivery_details wdd,

4638: ) IS
4639:
4640: CURSOR itemCur(in_lpn_id NUMBER) IS
4641: SELECT picked_quantity2
4642: FROM wsh_delivery_details wdd,
4643: mtl_system_items_b msib
4644: WHERE wdd.inventory_item_id = p_from_item_id
4645: AND wdd.inventory_item_id = msib.inventory_item_id
4646: AND wdd.organization_id = p_org_id

Line 4652: wsh_delivery_details wdd1

4648: AND NVL(wdd.revision,'@@@') = NVL(NVL(p_from_item_revision,wdd.revision),'@@@')
4649: AND NVL(wdd.lot_number,'@@@') = NVL(p_from_item_lot_number,'@@@')
4650: AND wdd.delivery_detail_id in (SELECT wda.delivery_detail_id
4651: FROM wsh_delivery_assignments_v wda,
4652: wsh_delivery_details wdd1
4653: WHERE wdd1.lpn_id = in_lpn_id
4654: AND wdd1.released_status = 'X' -- For LPN reuse ER : 6845650
4655: AND wdd1.delivery_detail_id = wda.parent_delivery_Detail_id
4656: AND wdd1.organization_id = p_org_id);

Line 4799: FROM wsh_delivery_details wdd,

4795: NULL,
4796: NULL)) requested_quantity,
4797: sum(picked_quantity2) picked_quantity2,
4798: msib.primary_uom_code
4799: FROM wsh_delivery_details wdd,
4800: mtl_system_items_b msib
4801: WHERE wdd.inventory_item_id = p_from_item_id
4802: AND wdd.inventory_item_id = msib.inventory_item_id
4803: AND wdd.organization_id = p_org_id

Line 4809: wsh_delivery_Details wdd1

4805: AND NVL(wdd.revision,'@@@') = NVL(p_from_item_revision,'@@@')
4806: AND NVL(wdd.lot_number,'@@@') = NVL(p_from_item_lot_number,'@@@')
4807: AND wdd.delivery_detail_id in (SELECT wda.delivery_detail_id
4808: FROM wsh_delivery_assignments_v wda,
4809: wsh_delivery_Details wdd1
4810: WHERE wdd1.lpn_id = p_from_lpn_id
4811: AND wdd1.released_status = 'X' -- For LPN reuse ER : 6845650
4812: AND wdd1.delivery_detail_id = wda.parent_delivery_Detail_id
4813: AND wdd1.organization_id = p_org_id)

Line 4952: FROM wsh_delivery_Details wdd,

4948: wdd.picked_quantity2,
4949: msi.primary_uom_code,
4950: msi.secondary_uom_code,
4951: msi.secondary_default_ind
4952: FROM wsh_delivery_Details wdd,
4953: mtl_system_items msi
4954: WHERE wdd.delivery_detail_id in
4955: (SELECT wda.delivery_detail_id
4956: FROM wsh_delivery_assignments_v wda,