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.WSH_MAPPING_DATA dependencies on WSH_DELIVERY_DETAILS

Line 60: FROM wsh_delivery_details wdd,

56:
57: CURSOR l_src_hdr_no_cur
58: IS
59: SELECT wdd.source_header_number
60: FROM wsh_delivery_details wdd,
61: wsh_delivery_assignments_v wda
62: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
63: AND wda.delivery_id = p_delivery_id
64: AND wdd.container_flag= 'N'

Line 115: wsh_delivery_details wdd

111: --bug 3920178 {
112: cursor l_ship_to_site_use_id_csr( p_delivery_id IN NUMBER) is
113: SELECT wdd.ship_to_site_use_id ship_to_site_use_id , count(*) cnt
114: FROM wsh_delivery_assignments_v wda,
115: wsh_delivery_details wdd
116: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
117: AND wda.delivery_id = p_delivery_id
118: AND wdd.container_flag = 'N'
119: GROUP BY ship_to_site_use_id

Line 870: FROM wsh_delivery_details wdd

866: HCSU.SITE_USE_CODE;
867:
868: CURSOR org_id_cur(p_del_detail_id NUMBER) IS
869: SELECT wdd.org_id org_id, count(*) cnt
870: FROM wsh_delivery_details wdd
871: WHERE wdd.delivery_detail_id IN
872: (SELECT wda.delivery_detail_id
873: FROM wsh_delivery_assignments_v wda
874: START WITH delivery_detail_id = p_del_detail_id

Line 950: FROM wsh_delivery_details wdd

946:
947: CURSOR l_get_ship_to_contact_csr (p_detail_id NUMBER)
948: IS
949: SELECT wdd.ship_to_contact_id
950: FROM wsh_delivery_details wdd
951: WHERE wdd.delivery_detail_id = p_detail_id
952: AND wdd.container_flag = 'N';
953:
954:

Line 1381: wsh_delivery_details wdd

1377:
1378: CURSOR l_ship_to_site_use_id_csr( c_delivery_id IN NUMBER) is
1379: SELECT wdd.ship_to_site_use_id ship_to_site_use_id , count(*) cnt
1380: FROM wsh_delivery_assignments_v wda,
1381: wsh_delivery_details wdd
1382: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
1383: AND wda.delivery_id = c_delivery_id
1384: AND wdd.container_flag = 'N'
1385: GROUP BY ship_to_site_use_id

Line 1689: FROM wsh_delivery_details wdd

1685:
1686: CURSOR l_get_contacts_csr (c_detail_id NUMBER)
1687: IS
1688: SELECT wdd.ship_to_contact_id
1689: FROM wsh_delivery_details wdd
1690: WHERE wdd.delivery_detail_id = c_detail_id
1691: AND wdd.container_flag = 'N';
1692:
1693: -- Distributed - TPW Changes

Line 1709: FROM WSH_DELIVERY_DETAILS

1705: SELECT rowidtochar(min(rowid)),count(*),sum(to_number(SERIAL_PREFIX))
1706: FROM mtl_serial_numbers_temp
1707: WHERE transaction_temp_id IN
1708: (SELECT transaction_temp_id
1709: FROM WSH_DELIVERY_DETAILS
1710: WHERE DELIVERY_DETAIL_ID = cp_delivery_detail_id
1711: AND SOURCE_CODE = 'OE');
1712:
1713: CURSOR get_msnt_qty(cp_wsn_rowid VARCHAR2) IS

Line 1783: from wsh_delivery_details

1779: IF p_detail_seq_number = 1 THEN --{
1780:
1781: select sum(requested_quantity)
1782: into x_open_quantity
1783: from wsh_delivery_details
1784: where source_line_id = p_src_line_id
1785: and source_code = 'OE'
1786: and released_status in ('N','R','S','Y');
1787:

Line 1790: from wsh_delivery_details

1786: and released_status in ('N','R','S','Y');
1787:
1788: select sum(requested_quantity)
1789: into x_bo_quantity
1790: from wsh_delivery_details
1791: where source_line_id = p_src_line_id
1792: and source_code = 'OE'
1793: and released_status = 'B';
1794:

Line 2028: FROM wsh_delivery_details wdd,

2024: SELECT ol.ship_to_org_id,
2025: ol.ship_to_contact_id,
2026: ol.deliver_to_org_id,
2027: ol.deliver_to_contact_id
2028: FROM wsh_delivery_details wdd,
2029: oe_order_lines_all ol
2030: WHERE wdd.delivery_detail_id = c_detail_id
2031: AND wdd.source_line_id = ol.line_id
2032: AND wdd.source_code = 'OE'

Line 2445: wsh_delivery_details wdd,

2441: SELECT ol.ship_to_org_id,
2442: ol.invoice_to_org_id
2443: FROM wsh_new_deliveries wnd,
2444: wsh_delivery_assignments_v wda,
2445: wsh_delivery_details wdd,
2446: oe_order_lines_all ol
2447: WHERE wnd.delivery_id = p_delivery_id
2448: AND wnd.delivery_id = wda.delivery_id
2449: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 2603: wsh_delivery_details wdd,

2599: select distinct ol.ship_to_contact_id
2600: into l_ship_to_contact_id
2601: from wsh_new_deliveries wnd,
2602: wsh_delivery_assignments_v wda,
2603: wsh_delivery_details wdd,
2604: oe_order_lines_all ol
2605: where wnd.delivery_id = p_delivery_id
2606: and wnd.delivery_id = wda.delivery_id
2607: and wda.delivery_detail_id = wdd.delivery_detail_id

Line 2663: wsh_delivery_details wdd,

2659: select distinct ol.invoice_to_contact_id
2660: into l_bill_to_contact_id
2661: from wsh_new_deliveries wnd,
2662: wsh_delivery_assignments_v wda,
2663: wsh_delivery_details wdd,
2664: oe_order_lines_all ol
2665: where wnd.delivery_id = p_delivery_id
2666: and wnd.delivery_id = wda.delivery_id
2667: and wda.delivery_detail_id = wdd.delivery_detail_id