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 421: wsh_delivery_details wdd,

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

Line 443: wsh_delivery_details_ob_grp_v wdd

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

Line 480: wsh_delivery_details wdd,

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

Line 486: wsh_delivery_details wdd2

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,
486: wsh_delivery_details wdd2
487: WHERE wdd.customer_id = cust_acct.cust_account_id -- Added for Bug# 4579790
488: --wdd.customer_id = c.customer_id -- Commented for Bug# 4579790
489: AND cust_acct.party_id = party.party_id -- Added for Bug# 4579790
490: AND wdd.organization_id = p_org_id

Line 515: wsh_delivery_details wdd,

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

Line 544: wsh_delivery_details wdd,

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

Line 550: wsh_delivery_details wdd2

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,
550: wsh_delivery_details wdd2
551: WHERE wdd.customer_id = cust_acct.cust_account_id -- Added for Bug# 4579790
552: --wdd.customer_id = c.customer_id -- Commented for Bug# 4579790
553: AND cust_acct.party_id = party.party_id -- Added for Bug# 4579790
554: AND wdd.organization_id = p_org_id

Line 579: wsh_delivery_details_ob_grp_v wdd,

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

Line 697: wsh_delivery_details wdd2,

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

Line 785: wsh_delivery_details wdd2,

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

Line 843: wsh_delivery_details wdd,

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

Line 844: wsh_delivery_details wdd2,

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

Line 862: wsh_delivery_details wdd,

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

Line 863: wsh_delivery_details wdd2,

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

Line 909: wsh_delivery_details wdd,

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

Line 981: wsh_delivery_details wdd,

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

Line 982: wsh_delivery_details wdd2,

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

Line 1113: wsh_delivery_details wdd,

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

Line 1233: wsh_delivery_details wdd,

1229: CURSOR lpn_csr2 IS
1230:
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

Line 1236: wsh_delivery_details wdd2

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

Line 1255: wsh_delivery_details wdd,

1251: CURSOR lpn_csr3 IS
1252:
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

Line 1446: wsh_delivery_details wdd,

1442: CURSOR lpn_csr IS
1443:
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

Line 1480: wsh_delivery_details wdd,

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

Line 1552: wsh_delivery_details wdd,

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

Line 1562: wsh_delivery_details wdd,

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

Line 2462: wsh_delivery_details wdd2,

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

Line 2477: wsh_delivery_details wdd1,

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