[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
421: wnd.delivery_id,
422: inv_shipping_transaction_pub.get_shipmethod_meaning(wnd.ship_method_code)
423: FROM
424: wsh_new_deliveries wnd,
425: wsh_delivery_assignments_v wda,
426: wsh_delivery_details wdd,
427: wms_license_plate_numbers wlpn
428: WHERE wda.parent_delivery_detail_id = wdd.delivery_detail_id
429: AND wda.delivery_id = wnd.delivery_id
443: wnd.name Delivery,
444: wnd.delivery_id,
445: inv_shipping_transaction_pub.get_shipmethod_meaning(wnd.ship_method_code)
446: FROM wsh_new_deliveries_ob_grp_v wnd,
447: wsh_delivery_assignments_v wda,
448: wsh_delivery_details_ob_grp_v wdd
449: WHERE wda.delivery_Detail_id = wdd.delivery_Detail_id
450: AND wda.delivery_id = wnd.delivery_id
451: AND wdd.released_status = 'Y'
482: --c.customer_name -- Commented for Bug# 4579790
483: party.party_name customer_name -- Added for Bug# 4579790
484: FROM
485: wsh_delivery_details wdd,
486: wsh_delivery_assignments_v wda,
487: -- ra_customers c, -- Commented for Bug# 4579790
488: hz_parties party, -- Added for Bug# 4579790
489: hz_cust_accounts cust_acct, -- Added for Bug# 4579790
490: wms_license_plate_numbers wlpn,
517: --c.customer_name -- Commented for Bug# 4579790
518: party.party_name customer_name -- Added for Bug# 4579790
519: FROM
520: wsh_delivery_details wdd,
521: wsh_delivery_assignments_v wda,
522: -- ra_customers c, -- Commented for Bug# 4579790
523: hz_parties party, -- Added for Bug# 4579790
524: hz_cust_accounts cust_acct -- Added for Bug# 4579790
525: WHERE wdd.customer_id = cust_acct.cust_account_id -- Added for Bug# 4579790
546: --c.customer_name -- Commented for Bug# 4579790
547: party.party_name customer_name -- Added for Bug# 4579790
548: FROM
549: wsh_delivery_details wdd,
550: wsh_delivery_assignments_v wda,
551: -- ra_customers c, -- Commented for Bug# 4579790
552: hz_parties party, -- Added for Bug# 4579790
553: hz_cust_accounts cust_acct, -- Added for Bug# 4579790
554: wms_license_plate_numbers wlpn,
581: --c.customer_name -- Commented for Bug# 4579790
582: party.party_name customer_name -- Added for Bug# 4579790
583: FROM
584: wsh_delivery_details_ob_grp_v wdd,
585: wsh_delivery_assignments_v wda,
586: -- ra_customers c, -- Commented for Bug# 4579790
587: hz_parties party, -- Added for Bug# 4579790
588: hz_cust_accounts cust_acct -- Added for Bug# 4579790
589: WHERE wdd.customer_id = cust_acct.cust_account_id -- Added for Bug# 4579790
699: mtl_item_locations_kfv milk,
700: mtl_item_locations mil,
701: wms_license_plate_numbers wlpn,
702: wsh_delivery_details wdd2,
703: wsh_delivery_assignments_v wda,
704: mfg_lookups ml
705: WHERE milk.organization_id = p_org_id
706: AND milk.subinventory_code = p_sub
707: AND milk.alias = p_alias
787: mtl_item_locations_kfv milk,
788: mtl_item_locations mil,
789: wms_license_plate_numbers wlpn,
790: wsh_delivery_details wdd2,
791: wsh_delivery_assignments_v wda,
792: mfg_lookups ml
793: WHERE milk.organization_id = p_org_id
794: AND milk.subinventory_code = p_sub
795: AND INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id) LIKE p_loc -- bug 2769126
843:
844: SELECT DISTINCT
845: wdd2.source_header_number
846: FROM
847: wsh_delivery_assignments_v wda,
848: wsh_delivery_details wdd,
849: wsh_delivery_details wdd2,
850: wms_license_plate_numbers wlpn
851: WHERE wlpn.outermost_lpn_id = p_lpn_id
862:
863: SELECT DISTINCT
864: wdd2.source_header_number
865: FROM
866: wsh_delivery_assignments_v wda,
867: wsh_delivery_details wdd,
868: wsh_delivery_details wdd2,
869: wms_license_plate_numbers wlpn
870: WHERE wlpn.outermost_lpn_id = p_lpn_id
909: l_loc_id,
910: x_project,
911: x_task
912: FROM
913: wsh_delivery_assignments_v wda,
914: wsh_delivery_details wdd,
915: wms_license_plate_numbers wlpn,
916: mtl_item_locations mil,
917: wms_license_plate_numbers wlpno
981: x_task
982: FROM
983: wms_license_plate_numbers wlpn,
984: wms_license_plate_numbers wlpno,
985: wsh_delivery_assignments_v wda,
986: wsh_delivery_details wdd,
987: wsh_delivery_details wdd2,
988: mtl_item_locations mil
989: WHERE wlpn.outermost_lpn_id = p_lpn_id
1113: x_task
1114: FROM
1115: wms_license_plate_numbers wlpn,
1116: wms_license_plate_numbers wlpno,
1117: wsh_delivery_assignments_v wda,
1118: wsh_delivery_details wdd,
1119: mtl_item_locations mil
1120: WHERE wlpn.outermost_lpn_id = p_lpn_id
1121: AND wlpno.lpn_id = p_lpn_id -- bug 2764736
1236: SELECT DISTINCT wlpn.outermost_lpn_id
1237: FROM
1238: wsh_delivery_details wdd,
1239: wms_license_plate_numbers wlpn,
1240: wsh_delivery_assignments_v wda,
1241: wsh_delivery_details wdd2
1242: WHERE wdd.source_header_number = x_order_number
1243: AND wdd.organization_id = p_org_id
1244: AND wdd.released_status = 'Y'
1258: SELECT DISTINCT wlpn.outermost_lpn_id
1259: FROM
1260: wsh_delivery_details wdd,
1261: wms_license_plate_numbers wlpn,
1262: wsh_delivery_assignments_v wda
1263: WHERE wda.delivery_id = x_delivery_id
1264: AND wdd.delivery_detail_id = wda.parent_delivery_detail_id
1265: AND wdd.organization_id = p_org_id
1266: AND wdd.lpn_id = wlpn.lpn_id
1449: SELECT DISTINCT wlpn.outermost_lpn_id
1450: FROM
1451: wsh_delivery_details wdd,
1452: wms_license_plate_numbers wlpn,
1453: wsh_delivery_assignments_v wda
1454: WHERE wda.delivery_id = x_delivery_id
1455: AND wdd.delivery_detail_id = wda.parent_delivery_detail_id
1456: AND wdd.organization_id = p_org_id
1457: AND wdd.lpn_id = wlpn.lpn_id
1482: mil.inventory_location_id))
1483: INTO x_tot_locs_for_del
1484: FROM mtl_item_locations mil,
1485: wsh_delivery_details wdd,
1486: wsh_delivery_assignments_v wda
1487: WHERE wda.delivery_id = x_delivery_id
1488: AND wda.delivery_detail_id = wdd.delivery_detail_id
1489: AND wdd.locator_id = mil.inventory_location_id
1490: AND wdd.organization_id = mil.organization_id
1554: SELECT COUNT(wdd.delivery_detail_id)
1555: INTO x_tot_lines_for_del
1556: FROM
1557: wsh_delivery_details wdd,
1558: wsh_delivery_assignments_v wda
1559: WHERE wdd.organization_id = p_org_id
1560: AND wdd.delivery_detail_id = wda.delivery_detail_id
1561: AND wda.delivery_id = x_delivery_id
1562: AND wdd.lpn_id IS NULL;
1564: SELECT COUNT(wdd.delivery_detail_id)
1565: INTO x_tot_comp_lines_for_del
1566: FROM
1567: wsh_delivery_details wdd,
1568: wsh_delivery_assignments_v wda
1569: WHERE wdd.organization_id = p_org_id
1570: AND wdd.released_status = 'Y'
1571: AND wdd.delivery_detail_id = wda.delivery_detail_id
1572: AND wda.delivery_id = x_delivery_id
2464: FROM
2465: wms_license_plate_numbers wlpn,
2466: -- wms_dispatched_tasks_history wdth, Commented by Bug#4337112.
2467: wsh_delivery_details wdd2,
2468: wsh_delivery_assignments_v wda
2469: WHERE wda.delivery_id = p_delivery_id
2470: AND wda.parent_delivery_detail_id = wdd2.delivery_detail_id
2471: AND wdd2.lpn_id = wlpn.lpn_id
2472: AND wlpn.lpn_context in ( 11,12)
2479: SELECT 1
2480: FROM
2481: mtl_material_transactions_temp mmtt,
2482: wsh_delivery_details wdd1,
2483: wsh_delivery_assignments_v wda2
2484: WHERE wda2.delivery_id = p_delivery_id
2485: AND wda2.delivery_detail_id = wdd1.delivery_detail_id
2486: AND wdd1.organization_id = p_org_id
2487: AND wdd1.released_status = 'S'
2728: l_from_loc
2729: From Mtl_Material_Transactions Mmt,
2730: Wms_Dispatched_Tasks_History Wdth,
2731: Wsh_Delivery_Details_Ob_Grp_v Wdd,
2732: Wsh_Delivery_Assignments Wda,
2733: Wsh_Delivery_Details_Ob_Grp_v Wddc,
2734: Wms_License_Plate_Numbers Wlpn
2735: Where 1 = 1
2736: And Decode(Mmt.Transfer_Transaction_Id,