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.GML_MOBILE_SHIP_CONFIRM dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 23: wsh_delivery_assignments wda

19:
20: CURSOR specified_ship_set IS
21: SELECT wdd.ship_set_id
22: FROM wsh_delivery_details wdd,
23: wsh_delivery_assignments wda
24: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
25: AND EXISTS (SELECT 'x'
26: FROM wsh_delivery_details wdd2
27: WHERE wdd2.delivery_detail_id = wdd.delivery_detail_id

Line 41: wsh_delivery_assignments wda,

37: EXIT WHEN specified_ship_set%NOTFOUND;
38: SELECT count(*)
39: INTO unshipped_count
40: FROM wsh_delivery_details wdd,
41: wsh_delivery_assignments wda,
42: wsh_new_deliveries wnd
43: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
44: AND wda.delivery_id = wnd.delivery_id
45: AND wnd.delivery_id = p_delivery_id

Line 83: wsh_delivery_assignments wda

79: into exist_unspecified
80: from dual
81: where exists (select 1
82: from wsh_delivery_details wdd,
83: wsh_delivery_assignments wda
84: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
85: AND wdd.shipped_quantity is null
86: AND wda.delivery_id = p_delivery_id
87: );

Line 113: wsh_delivery_assignments da, mtl_system_items_kfv msik

109: nvl(dd.transaction_temp_id,0),
110: dd.picked_quantity, dd.requested_quantity_uom2, NVL(dd.lot_number, ' '), NVL(dd.picked_quantity2,0)
111: ---FROM wsh_new_deliveries_ob_grp_v del, wsh_delivery_details_ob_grp_v dd,
112: FROM wsh_new_deliveries del, wsh_delivery_details dd,
113: wsh_delivery_assignments da, mtl_system_items_kfv msik
114: WHERE da.delivery_id = del.delivery_id
115: AND da.delivery_detail_id = dd.delivery_detail_id
116: AND ( dd.inventory_item_id = p_inventory_item_id or p_inventory_item_id = -1 )
117: AND NVL( dd.inv_interfaced_flag, 'N') = 'N'

Line 153: ---from wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments wda, wsh_delivery_details_ob_grp_v wdd2

149: WHERE dd.delivery_detail_id = p_delivery_detail_id;
150:
151: cursor lpn_csr(p_delivery_detail_id in NUMBER) is
152: select wdd.delivery_detail_id, wda.delivery_assignment_id,wda2.delivery_assignment_id
153: ---from wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments wda, wsh_delivery_details_ob_grp_v wdd2
154: from wsh_delivery_details wdd, wsh_delivery_assignments wda, wsh_delivery_details wdd2
155: , wsh_delivery_assignments wda2
156: where wdd.delivery_detail_id = wda.parent_delivery_detail_id
157: and wda.delivery_detail_id = wdd2.delivery_detail_id

Line 154: from wsh_delivery_details wdd, wsh_delivery_assignments wda, wsh_delivery_details wdd2

150:
151: cursor lpn_csr(p_delivery_detail_id in NUMBER) is
152: select wdd.delivery_detail_id, wda.delivery_assignment_id,wda2.delivery_assignment_id
153: ---from wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments wda, wsh_delivery_details_ob_grp_v wdd2
154: from wsh_delivery_details wdd, wsh_delivery_assignments wda, wsh_delivery_details wdd2
155: , wsh_delivery_assignments wda2
156: where wdd.delivery_detail_id = wda.parent_delivery_detail_id
157: and wda.delivery_detail_id = wdd2.delivery_detail_id
158: and wdd2.delivery_detail_id = p_delivery_detail_id

Line 155: , wsh_delivery_assignments wda2

151: cursor lpn_csr(p_delivery_detail_id in NUMBER) is
152: select wdd.delivery_detail_id, wda.delivery_assignment_id,wda2.delivery_assignment_id
153: ---from wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments wda, wsh_delivery_details_ob_grp_v wdd2
154: from wsh_delivery_details wdd, wsh_delivery_assignments wda, wsh_delivery_details wdd2
155: , wsh_delivery_assignments wda2
156: where wdd.delivery_detail_id = wda.parent_delivery_detail_id
157: and wda.delivery_detail_id = wdd2.delivery_detail_id
158: and wdd2.delivery_detail_id = p_delivery_detail_id
159: and wda2.delivery_detail_id = wdd.delivery_detail_id;

Line 713: FROM wsh_new_deliveries wnd, wsh_delivery_assignments wda,wsh_delivery_details wdd

709: SELECT distinct wnd.name, wnd.delivery_id, wnd.gross_weight, wnd.weight_uom_code,
710:
711: wnd.waybill,
712: Get_Shipmethod_Meaning(wnd.ship_method_code)
713: FROM wsh_new_deliveries wnd, wsh_delivery_assignments wda,wsh_delivery_details wdd
714:
715: WHERE wda.delivery_Detail_id = wdd.delivery_Detail_id
716: AND wda.delivery_id = wnd.delivery_id
717: and ( wdd.released_status = 'Y' or wdd.released_status = 'X')

Line 750: FROM mtl_system_items_kfv msik, wsh_delivery_details dd, wsh_delivery_assignments da,

746: OPEN x_items FOR
747: SELECT DISTINCT msik.concatenated_segments concatenated_segments
748: , msik.inventory_item_id
749: , msik.description
750: FROM mtl_system_items_kfv msik, wsh_delivery_details dd, wsh_delivery_assignments da,
751: wsh_new_deliveries nd
752: WHERE msik.concatenated_segments LIKE (p_concatenated_segments)
753: AND msik.organization_id = p_organization_id
754: AND msik.inventory_item_id = dd.inventory_item_id

Line 771: wsh_delivery_assignments da,

767: , msik.inventory_item_id
768: , msik.description
769: FROM mtl_system_items_kfv msik,
770: wsh_delivery_details dd,
771: wsh_delivery_assignments da,
772: wsh_new_deliveries nd,
773: mtl_cross_references mcr
774: WHERE msik.organization_id = p_organization_id
775: AND msik.inventory_item_id = dd.inventory_item_id