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_PICK_DROP_PVT dependencies on WSH_DELIVERY_DETAILS_OB_GRP_V

Line 256: wsh_delivery_details_ob_grp_v wdd,

252: ( p_tmp_id IN NUMBER
253: ) IS
254: SELECT wda.delivery_id
255: FROM wsh_delivery_assignments_v wda,
256: wsh_delivery_details_ob_grp_v wdd,
257: mtl_material_transactions_temp mmtt
258: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
259: AND wdd.move_order_line_id = mmtt.move_order_line_id
260: AND wdd.organization_id = mmtt.organization_id

Line 280: wsh_delivery_details_ob_grp_v wdd,

276: IF p_drop_type = 'CONS_STG_MV' THEN
277: SELECT wda.delivery_id
278: INTO x_delivery_id
279: FROM wsh_delivery_assignments_v wda,
280: wsh_delivery_details_ob_grp_v wdd,
281: mtl_material_transactions_temp mmtt
282: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
283: AND wdd.organization_id = mmtt.organization_id
284: AND mmtt.transaction_temp_id = p_temp_id

Line 948: , wsh_delivery_details_ob_grp_v wdd

944: )
945: )
946: FROM mtl_material_transactions_temp mmtt
947: , mtl_txn_request_lines mtrl
948: , wsh_delivery_details_ob_grp_v wdd
949: , wsh_delivery_assignments_v wda
950: WHERE mmtt.organization_id = p_org_id
951: --Modified for Bug 6717052
952: AND (mmtt.transfer_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id IN (SELECT wlpn.lpn_id FROM wms_license_plate_numbers wlpn

Line 3362: , wsh_delivery_details_ob_grp_v wdd

3358: FROM mtl_material_transactions_temp mmtt
3359: , mtl_secondary_inventories msi
3360: , mtl_item_locations mil
3361: , mtl_txn_request_lines mtrl
3362: , wsh_delivery_details_ob_grp_v wdd
3363: , wsh_delivery_assignments_v wda
3364: WHERE mmtt.organization_id = p_org_id
3365: AND mmtt.transfer_lpn_id = p_lpn_id
3366: AND mmtt.transaction_action_id = 28

Line 4253: , wsh_delivery_details_ob_grp_v wdd

4249: , p_loc_id IN NUMBER
4250: ) IS
4251: SELECT wlpn.outermost_lpn_id
4252: FROM wsh_delivery_assignments_v wda
4253: , wsh_delivery_details_ob_grp_v wdd
4254: , wms_license_plate_numbers wlpn
4255: WHERE wda.delivery_id = p_deliv_id
4256: AND wda.parent_delivery_detail_id = wdd.delivery_detail_id
4257: AND wdd.organization_id = p_org_id

Line 7398: FROM wsh_delivery_details_ob_grp_v wdd

7394: ( p_lpn_id IN NUMBER
7395: , p_org_id IN NUMBER
7396: ) IS
7397: SELECT wda.delivery_id
7398: FROM wsh_delivery_details_ob_grp_v wdd
7399: , wsh_delivery_assignments_v wda
7400: WHERE wdd.lpn_id = p_lpn_id
7401: AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650
7402: AND wdd.organization_id = p_org_id

Line 7416: , wsh_delivery_details_ob_grp_v wdd

7412: , mtrl.carton_grouping_id
7413: , wda.delivery_id
7414: FROM mtl_material_transactions_temp mmtt
7415: , mtl_txn_request_lines mtrl
7416: , wsh_delivery_details_ob_grp_v wdd
7417: , wsh_delivery_assignments_v wda
7418: WHERE mmtt.organization_id = p_org_id
7419: AND mmtt.transfer_lpn_id = p_lpn_id
7420: AND mmtt.move_order_line_id = mtrl.line_id

Line 7432: FROM wsh_delivery_details_ob_grp_v wdd

7428: ( p_lpn_id IN NUMBER
7429: , p_org_id IN NUMBER
7430: ) IS
7431: SELECT mtrl.carton_grouping_id
7432: FROM wsh_delivery_details_ob_grp_v wdd
7433: , wsh_delivery_assignments_v wda
7434: , wsh_delivery_details_ob_grp_v wdd2
7435: , mtl_txn_request_lines mtrl
7436: WHERE wdd.lpn_id = p_lpn_id

Line 7434: , wsh_delivery_details_ob_grp_v wdd2

7430: ) IS
7431: SELECT mtrl.carton_grouping_id
7432: FROM wsh_delivery_details_ob_grp_v wdd
7433: , wsh_delivery_assignments_v wda
7434: , wsh_delivery_details_ob_grp_v wdd2
7435: , mtl_txn_request_lines mtrl
7436: WHERE wdd.lpn_id = p_lpn_id
7437: AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650
7438: AND wdd.organization_id = p_org_id

Line 10205: , wsh_delivery_details_ob_grp_v wdd

10201: ) IS
10202: SELECT MIN(ooha.order_number)
10203: , COUNT(DISTINCT ooha.order_number)
10204: FROM wsh_delivery_assignments_v wda
10205: , wsh_delivery_details_ob_grp_v wdd
10206: , oe_order_lines_all oola
10207: , oe_order_headers_all ooha
10208: WHERE wda.delivery_id = p_del_id
10209: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 10470: , wsh_delivery_details_ob_grp_v wdd

10466: , p_org_id IN NUMBER
10467: ) IS
10468: SELECT wda.delivery_id
10469: FROM wsh_delivery_assignments_v wda
10470: , wsh_delivery_details_ob_grp_v wdd
10471: , wms_license_plate_numbers lpn
10472: WHERE wda.parent_delivery_detail_id = wdd.delivery_detail_id
10473: AND wdd.organization_id = p_org_id
10474: AND wdd.lpn_id = lpn.lpn_id

Line 10778: FROM wsh_delivery_details_ob_grp_v

10774: /*Bug#4106176.The following block is added.*/
10775: /* BEGIN -- mrana: need to figure this out later
10776: SELECT delivery_detail_id
10777: INTO l_line_rows(1)
10778: FROM wsh_delivery_details_ob_grp_v
10779: WHERE lpn_id = drop_lpn_rec.lpn_id
10780: AND rownum = 1 ;
10781:
10782: SELECT wdd.delivery_detail_id

Line 10784: FROM wsh_delivery_details_ob_grp_v wdd, Mtl_material_transactions_temp mmtt

10780: AND rownum = 1 ;
10781:
10782: SELECT wdd.delivery_detail_id
10783: INTO l_line_rows(2)
10784: FROM wsh_delivery_details_ob_grp_v wdd, Mtl_material_transactions_temp mmtt
10785: WHERE mmtt.move_order_line_id = wdd.move_order_line_id
10786: AND wdd.organization_id = mmtt.organization_id
10787: AND mmtt.organization_id= p_organization_id
10788: AND mmtt.transfer_lpn_id= p_transfer_lpn_id