[Home] [Help]
29: mil.inventory_location_id
30: FROM
31: wms_license_plate_numbers wlpn,
32: wsh_delivery_details wdd,
33: wsh_delivery_assignments_v wda,
34: mtl_item_locations mil
35: WHERE wlpn.organization_id = p_org_id
36: AND wlpn.locator_id = mil.inventory_location_id
37: AND Nvl(mil.physical_location_id, mil.inventory_location_id) = p_loc_id
191: mtl_item_locations_kfv milk,
192: mtl_item_locations mil,
193: wms_license_plate_numbers wlpn,
194: wsh_delivery_details wdd2,
195: wsh_delivery_assignments_v wda,
196: mfg_lookups ml
197: WHERE milk.organization_id = p_org_id
198: AND milk.subinventory_code = p_sub
199: AND milk.concatenated_segments LIKE l_loc
416: wnd.delivery_id,
417: inv_shipping_transaction_pub.get_shipmethod_meaning(wnd.ship_method_code)
418: FROM
419: wsh_new_deliveries wnd,
420: wsh_delivery_assignments_v wda,
421: wsh_delivery_details wdd,
422: wms_license_plate_numbers wlpn
423: WHERE wda.parent_delivery_detail_id = wdd.delivery_detail_id
424: AND wda.delivery_id = wnd.delivery_id
438: wnd.name Delivery,
439: wnd.delivery_id,
440: inv_shipping_transaction_pub.get_shipmethod_meaning(wnd.ship_method_code)
441: FROM wsh_new_deliveries_ob_grp_v wnd,
442: wsh_delivery_assignments_v wda,
443: wsh_delivery_details_ob_grp_v wdd
444: WHERE wda.delivery_Detail_id = wdd.delivery_Detail_id
445: AND wda.delivery_id = wnd.delivery_id
446: AND wdd.released_status = 'Y'
477: --c.customer_name -- Commented for Bug# 4579790
478: party.party_name customer_name -- Added for Bug# 4579790
479: FROM
480: wsh_delivery_details wdd,
481: wsh_delivery_assignments_v wda,
482: -- ra_customers c, -- Commented for Bug# 4579790
483: hz_parties party, -- Added for Bug# 4579790
484: hz_cust_accounts cust_acct, -- Added for Bug# 4579790
485: wms_license_plate_numbers wlpn,
512: --c.customer_name -- Commented for Bug# 4579790
513: party.party_name customer_name -- Added for Bug# 4579790
514: FROM
515: wsh_delivery_details wdd,
516: wsh_delivery_assignments_v wda,
517: -- ra_customers c, -- Commented for Bug# 4579790
518: hz_parties party, -- Added for Bug# 4579790
519: hz_cust_accounts cust_acct -- Added for Bug# 4579790
520: WHERE wdd.customer_id = cust_acct.cust_account_id -- Added for Bug# 4579790
541: --c.customer_name -- Commented for Bug# 4579790
542: party.party_name customer_name -- Added for Bug# 4579790
543: FROM
544: wsh_delivery_details wdd,
545: wsh_delivery_assignments_v wda,
546: -- ra_customers c, -- Commented for Bug# 4579790
547: hz_parties party, -- Added for Bug# 4579790
548: hz_cust_accounts cust_acct, -- Added for Bug# 4579790
549: wms_license_plate_numbers wlpn,
576: --c.customer_name -- Commented for Bug# 4579790
577: party.party_name customer_name -- Added for Bug# 4579790
578: FROM
579: wsh_delivery_details_ob_grp_v wdd,
580: wsh_delivery_assignments_v wda,
581: -- ra_customers c, -- Commented for Bug# 4579790
582: hz_parties party, -- Added for Bug# 4579790
583: hz_cust_accounts cust_acct -- Added for Bug# 4579790
584: WHERE wdd.customer_id = cust_acct.cust_account_id -- Added for Bug# 4579790
694: mtl_item_locations_kfv milk,
695: mtl_item_locations mil,
696: wms_license_plate_numbers wlpn,
697: wsh_delivery_details wdd2,
698: wsh_delivery_assignments_v wda,
699: mfg_lookups ml
700: WHERE milk.organization_id = p_org_id
701: AND milk.subinventory_code = p_sub
702: AND milk.alias = p_alias
782: mtl_item_locations_kfv milk,
783: mtl_item_locations mil,
784: wms_license_plate_numbers wlpn,
785: wsh_delivery_details wdd2,
786: wsh_delivery_assignments_v wda,
787: mfg_lookups ml
788: WHERE milk.organization_id = p_org_id
789: AND milk.subinventory_code = p_sub
790: AND INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) LIKE p_loc -- bug 2769126
838:
839: SELECT DISTINCT
840: wdd2.source_header_number
841: FROM
842: wsh_delivery_assignments_v wda,
843: wsh_delivery_details wdd,
844: wsh_delivery_details wdd2,
845: wms_license_plate_numbers wlpn
846: WHERE wlpn.outermost_lpn_id = p_lpn_id
857:
858: SELECT DISTINCT
859: wdd2.source_header_number
860: FROM
861: wsh_delivery_assignments_v wda,
862: wsh_delivery_details wdd,
863: wsh_delivery_details wdd2,
864: wms_license_plate_numbers wlpn
865: WHERE wlpn.outermost_lpn_id = p_lpn_id
904: l_loc_id,
905: x_project,
906: x_task
907: FROM
908: wsh_delivery_assignments_v wda,
909: wsh_delivery_details wdd,
910: wms_license_plate_numbers wlpn,
911: mtl_item_locations mil,
912: wms_license_plate_numbers wlpno
976: x_task
977: FROM
978: wms_license_plate_numbers wlpn,
979: wms_license_plate_numbers wlpno,
980: wsh_delivery_assignments_v wda,
981: wsh_delivery_details wdd,
982: wsh_delivery_details wdd2,
983: mtl_item_locations mil
984: WHERE wlpn.outermost_lpn_id = p_lpn_id
1108: x_task
1109: FROM
1110: wms_license_plate_numbers wlpn,
1111: wms_license_plate_numbers wlpno,
1112: wsh_delivery_assignments_v wda,
1113: wsh_delivery_details wdd,
1114: mtl_item_locations mil
1115: WHERE wlpn.outermost_lpn_id = p_lpn_id
1116: AND wlpno.lpn_id = p_lpn_id -- bug 2764736
1231: SELECT DISTINCT wlpn.outermost_lpn_id
1232: FROM
1233: wsh_delivery_details wdd,
1234: wms_license_plate_numbers wlpn,
1235: wsh_delivery_assignments_v wda,
1236: wsh_delivery_details wdd2
1237: WHERE wdd.source_header_number = x_order_number
1238: AND wdd.organization_id = p_org_id
1239: AND wdd.released_status = 'Y'
1253: SELECT DISTINCT wlpn.outermost_lpn_id
1254: FROM
1255: wsh_delivery_details wdd,
1256: wms_license_plate_numbers wlpn,
1257: wsh_delivery_assignments_v wda
1258: WHERE wda.delivery_id = x_delivery_id
1259: AND wdd.delivery_detail_id = wda.parent_delivery_detail_id
1260: AND wdd.organization_id = p_org_id
1261: AND wdd.lpn_id = wlpn.lpn_id
1444: SELECT DISTINCT wlpn.outermost_lpn_id
1445: FROM
1446: wsh_delivery_details wdd,
1447: wms_license_plate_numbers wlpn,
1448: wsh_delivery_assignments_v wda
1449: WHERE wda.delivery_id = x_delivery_id
1450: AND wdd.delivery_detail_id = wda.parent_delivery_detail_id
1451: AND wdd.organization_id = p_org_id
1452: AND wdd.lpn_id = wlpn.lpn_id
1477: mil.inventory_location_id))
1478: INTO x_tot_locs_for_del
1479: FROM mtl_item_locations mil,
1480: wsh_delivery_details wdd,
1481: wsh_delivery_assignments_v wda
1482: WHERE wda.delivery_id = x_delivery_id
1483: AND wda.delivery_detail_id = wdd.delivery_detail_id
1484: AND wdd.locator_id = mil.inventory_location_id
1485: AND wdd.organization_id = mil.organization_id
1549: SELECT COUNT(wdd.delivery_detail_id)
1550: INTO x_tot_lines_for_del
1551: FROM
1552: wsh_delivery_details wdd,
1553: wsh_delivery_assignments_v wda
1554: WHERE wdd.organization_id = p_org_id
1555: AND wdd.delivery_detail_id = wda.delivery_detail_id
1556: AND wda.delivery_id = x_delivery_id
1557: AND wdd.lpn_id IS NULL;
1559: SELECT COUNT(wdd.delivery_detail_id)
1560: INTO x_tot_comp_lines_for_del
1561: FROM
1562: wsh_delivery_details wdd,
1563: wsh_delivery_assignments_v wda
1564: WHERE wdd.organization_id = p_org_id
1565: AND wdd.released_status = 'Y'
1566: AND wdd.delivery_detail_id = wda.delivery_detail_id
1567: AND wda.delivery_id = x_delivery_id
2459: FROM
2460: wms_license_plate_numbers wlpn,
2461: -- wms_dispatched_tasks_history wdth, Commented by Bug#4337112.
2462: wsh_delivery_details wdd2,
2463: wsh_delivery_assignments_v wda
2464: WHERE wda.delivery_id = p_delivery_id
2465: AND wda.parent_delivery_detail_id = wdd2.delivery_detail_id
2466: AND wdd2.lpn_id = wlpn.lpn_id
2467: AND wlpn.lpn_context in ( 11,12)
2474: SELECT 1
2475: FROM
2476: mtl_material_transactions_temp mmtt,
2477: wsh_delivery_details wdd1,
2478: wsh_delivery_assignments_v wda2
2479: WHERE wda2.delivery_id = p_delivery_id
2480: AND wda2.delivery_detail_id = wdd1.delivery_detail_id
2481: AND wdd1.organization_id = p_org_id
2482: AND wdd1.released_status = 'S'