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_CONSOLIDATION_PUB dependencies on WSH_DELIVERY_DETAILS

Line 32: wsh_delivery_details wdd,

28: wda.delivery_id,
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

Line 194: wsh_delivery_details wdd2,

190: FROM
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

Line 426: wsh_delivery_details wdd,

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
430: AND wnd.name LIKE p_delivery_name

Line 448: wsh_delivery_details_ob_grp_v wdd

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'
452: AND wnd.organization_id = p_organization_id

Line 485: wsh_delivery_details wdd,

481: wda.delivery_id,
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

Line 491: wsh_delivery_details wdd2

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,
491: wsh_delivery_details wdd2
492: WHERE wdd.customer_id = cust_acct.cust_account_id -- Added for Bug# 4579790
493: --wdd.customer_id = c.customer_id -- Commented for Bug# 4579790
494: AND cust_acct.party_id = party.party_id -- Added for Bug# 4579790
495: AND wdd.organization_id = p_org_id

Line 520: wsh_delivery_details wdd,

516: wda.delivery_id,
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

Line 549: wsh_delivery_details wdd,

545: wda.delivery_id,
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

Line 555: wsh_delivery_details wdd2

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,
555: wsh_delivery_details wdd2
556: WHERE wdd.customer_id = cust_acct.cust_account_id -- Added for Bug# 4579790
557: --wdd.customer_id = c.customer_id -- Commented for Bug# 4579790
558: AND cust_acct.party_id = party.party_id -- Added for Bug# 4579790
559: AND wdd.organization_id = p_org_id

Line 584: wsh_delivery_details_ob_grp_v wdd,

580: wda.delivery_id,
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

Line 702: wsh_delivery_details wdd2,

698: FROM
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

Line 790: wsh_delivery_details wdd2,

786: FROM
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

Line 848: wsh_delivery_details wdd,

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
852: AND wlpn.organization_id = p_org_id

Line 849: wsh_delivery_details wdd2,

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
852: AND wlpn.organization_id = p_org_id
853: AND wlpn.lpn_context in ( 11,12)

Line 867: wsh_delivery_details wdd,

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
871: AND wlpn.organization_id = p_org_id

Line 868: wsh_delivery_details wdd2,

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
871: AND wlpn.organization_id = p_org_id
872: AND wlpn.lpn_context in ( 11,12)

Line 914: wsh_delivery_details wdd,

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
918: WHERE wlpn.organization_id = p_org_id

Line 986: wsh_delivery_details wdd,

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
990: AND wlpno.lpn_id = p_lpn_id -- bug 2764736

Line 987: wsh_delivery_details wdd2,

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
990: AND wlpno.lpn_id = p_lpn_id -- bug 2764736
991: AND wlpn.lpn_context in ( 11, 12)

Line 1118: wsh_delivery_details wdd,

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
1122: AND wlpn.lpn_context in ( 11,12)

Line 1238: wsh_delivery_details wdd,

1234: CURSOR lpn_csr2 IS
1235:
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

Line 1241: wsh_delivery_details wdd2

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'
1245: AND wdd.delivery_detail_id = wda.delivery_detail_id

Line 1260: wsh_delivery_details wdd,

1256: CURSOR lpn_csr3 IS
1257:
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

Line 1451: wsh_delivery_details wdd,

1447: CURSOR lpn_csr IS
1448:
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

Line 1485: wsh_delivery_details wdd,

1481: SELECT COUNT(DISTINCT Nvl(mil.physical_location_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

Line 1557: wsh_delivery_details wdd,

1553:
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

Line 1567: wsh_delivery_details wdd,

1563:
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

Line 2467: wsh_delivery_details wdd2,

2463: INTO l_count
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

Line 2482: wsh_delivery_details wdd1,

2478: (
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

Line 2731: Wsh_Delivery_Details_Ob_Grp_v Wdd,

2727: l_from_sub,
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

Line 2733: Wsh_Delivery_Details_Ob_Grp_v Wddc,

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,
2737: Null,