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

Line 18: wdd_source_header_number wsh_delivery_details.source_header_number%TYPE,

14:
15: TYPE g_dc_tbl_type IS TABLE OF g_dc_rec_type INDEX BY BINARY_INTEGER;
16:
17: TYPE t_dc_columns_rec_type IS RECORD(
18: wdd_source_header_number wsh_delivery_details.source_header_number%TYPE,
19: wdd_source_line_number wsh_delivery_details.source_line_number%TYPE,
20: wdd_delivery_detail_id wsh_delivery_details.delivery_detail_id%TYPE,
21: wdd_released_status wsh_delivery_details.released_status%TYPE,
22: wdd_requested_quantity wsh_delivery_details.requested_quantity%TYPE,

Line 19: wdd_source_line_number wsh_delivery_details.source_line_number%TYPE,

15: TYPE g_dc_tbl_type IS TABLE OF g_dc_rec_type INDEX BY BINARY_INTEGER;
16:
17: TYPE t_dc_columns_rec_type IS RECORD(
18: wdd_source_header_number wsh_delivery_details.source_header_number%TYPE,
19: wdd_source_line_number wsh_delivery_details.source_line_number%TYPE,
20: wdd_delivery_detail_id wsh_delivery_details.delivery_detail_id%TYPE,
21: wdd_released_status wsh_delivery_details.released_status%TYPE,
22: wdd_requested_quantity wsh_delivery_details.requested_quantity%TYPE,
23: wdd_source_code wsh_delivery_details.source_code%TYPE,

Line 20: wdd_delivery_detail_id wsh_delivery_details.delivery_detail_id%TYPE,

16:
17: TYPE t_dc_columns_rec_type IS RECORD(
18: wdd_source_header_number wsh_delivery_details.source_header_number%TYPE,
19: wdd_source_line_number wsh_delivery_details.source_line_number%TYPE,
20: wdd_delivery_detail_id wsh_delivery_details.delivery_detail_id%TYPE,
21: wdd_released_status wsh_delivery_details.released_status%TYPE,
22: wdd_requested_quantity wsh_delivery_details.requested_quantity%TYPE,
23: wdd_source_code wsh_delivery_details.source_code%TYPE,
24: wdd_batch_id wsh_delivery_details.batch_id%TYPE,

Line 21: wdd_released_status wsh_delivery_details.released_status%TYPE,

17: TYPE t_dc_columns_rec_type IS RECORD(
18: wdd_source_header_number wsh_delivery_details.source_header_number%TYPE,
19: wdd_source_line_number wsh_delivery_details.source_line_number%TYPE,
20: wdd_delivery_detail_id wsh_delivery_details.delivery_detail_id%TYPE,
21: wdd_released_status wsh_delivery_details.released_status%TYPE,
22: wdd_requested_quantity wsh_delivery_details.requested_quantity%TYPE,
23: wdd_source_code wsh_delivery_details.source_code%TYPE,
24: wdd_batch_id wsh_delivery_details.batch_id%TYPE,
25: wdd_source_line_id wsh_delivery_details.source_line_id%TYPE,

Line 22: wdd_requested_quantity wsh_delivery_details.requested_quantity%TYPE,

18: wdd_source_header_number wsh_delivery_details.source_header_number%TYPE,
19: wdd_source_line_number wsh_delivery_details.source_line_number%TYPE,
20: wdd_delivery_detail_id wsh_delivery_details.delivery_detail_id%TYPE,
21: wdd_released_status wsh_delivery_details.released_status%TYPE,
22: wdd_requested_quantity wsh_delivery_details.requested_quantity%TYPE,
23: wdd_source_code wsh_delivery_details.source_code%TYPE,
24: wdd_batch_id wsh_delivery_details.batch_id%TYPE,
25: wdd_source_line_id wsh_delivery_details.source_line_id%TYPE,
26: wdd_source_header_id wsh_delivery_details.source_header_id%TYPE,

Line 23: wdd_source_code wsh_delivery_details.source_code%TYPE,

19: wdd_source_line_number wsh_delivery_details.source_line_number%TYPE,
20: wdd_delivery_detail_id wsh_delivery_details.delivery_detail_id%TYPE,
21: wdd_released_status wsh_delivery_details.released_status%TYPE,
22: wdd_requested_quantity wsh_delivery_details.requested_quantity%TYPE,
23: wdd_source_code wsh_delivery_details.source_code%TYPE,
24: wdd_batch_id wsh_delivery_details.batch_id%TYPE,
25: wdd_source_line_id wsh_delivery_details.source_line_id%TYPE,
26: wdd_source_header_id wsh_delivery_details.source_header_id%TYPE,
27: wdd_oe_interfaced_flag wsh_delivery_details.oe_interfaced_flag%TYPE,

Line 24: wdd_batch_id wsh_delivery_details.batch_id%TYPE,

20: wdd_delivery_detail_id wsh_delivery_details.delivery_detail_id%TYPE,
21: wdd_released_status wsh_delivery_details.released_status%TYPE,
22: wdd_requested_quantity wsh_delivery_details.requested_quantity%TYPE,
23: wdd_source_code wsh_delivery_details.source_code%TYPE,
24: wdd_batch_id wsh_delivery_details.batch_id%TYPE,
25: wdd_source_line_id wsh_delivery_details.source_line_id%TYPE,
26: wdd_source_header_id wsh_delivery_details.source_header_id%TYPE,
27: wdd_oe_interfaced_flag wsh_delivery_details.oe_interfaced_flag%TYPE,
28: wdd_inv_interfaced_flag wsh_delivery_details.inv_interfaced_flag%TYPE,

Line 25: wdd_source_line_id wsh_delivery_details.source_line_id%TYPE,

21: wdd_released_status wsh_delivery_details.released_status%TYPE,
22: wdd_requested_quantity wsh_delivery_details.requested_quantity%TYPE,
23: wdd_source_code wsh_delivery_details.source_code%TYPE,
24: wdd_batch_id wsh_delivery_details.batch_id%TYPE,
25: wdd_source_line_id wsh_delivery_details.source_line_id%TYPE,
26: wdd_source_header_id wsh_delivery_details.source_header_id%TYPE,
27: wdd_oe_interfaced_flag wsh_delivery_details.oe_interfaced_flag%TYPE,
28: wdd_inv_interfaced_flag wsh_delivery_details.inv_interfaced_flag%TYPE,
29: wdd_ship_set_id wsh_delivery_details.ship_set_id%TYPE,

Line 26: wdd_source_header_id wsh_delivery_details.source_header_id%TYPE,

22: wdd_requested_quantity wsh_delivery_details.requested_quantity%TYPE,
23: wdd_source_code wsh_delivery_details.source_code%TYPE,
24: wdd_batch_id wsh_delivery_details.batch_id%TYPE,
25: wdd_source_line_id wsh_delivery_details.source_line_id%TYPE,
26: wdd_source_header_id wsh_delivery_details.source_header_id%TYPE,
27: wdd_oe_interfaced_flag wsh_delivery_details.oe_interfaced_flag%TYPE,
28: wdd_inv_interfaced_flag wsh_delivery_details.inv_interfaced_flag%TYPE,
29: wdd_ship_set_id wsh_delivery_details.ship_set_id%TYPE,
30: wdd_date_requested wsh_delivery_details.date_requested%TYPE,

Line 27: wdd_oe_interfaced_flag wsh_delivery_details.oe_interfaced_flag%TYPE,

23: wdd_source_code wsh_delivery_details.source_code%TYPE,
24: wdd_batch_id wsh_delivery_details.batch_id%TYPE,
25: wdd_source_line_id wsh_delivery_details.source_line_id%TYPE,
26: wdd_source_header_id wsh_delivery_details.source_header_id%TYPE,
27: wdd_oe_interfaced_flag wsh_delivery_details.oe_interfaced_flag%TYPE,
28: wdd_inv_interfaced_flag wsh_delivery_details.inv_interfaced_flag%TYPE,
29: wdd_ship_set_id wsh_delivery_details.ship_set_id%TYPE,
30: wdd_date_requested wsh_delivery_details.date_requested%TYPE,
31: wdd_date_scheduled wsh_delivery_details.date_scheduled%TYPE,

Line 28: wdd_inv_interfaced_flag wsh_delivery_details.inv_interfaced_flag%TYPE,

24: wdd_batch_id wsh_delivery_details.batch_id%TYPE,
25: wdd_source_line_id wsh_delivery_details.source_line_id%TYPE,
26: wdd_source_header_id wsh_delivery_details.source_header_id%TYPE,
27: wdd_oe_interfaced_flag wsh_delivery_details.oe_interfaced_flag%TYPE,
28: wdd_inv_interfaced_flag wsh_delivery_details.inv_interfaced_flag%TYPE,
29: wdd_ship_set_id wsh_delivery_details.ship_set_id%TYPE,
30: wdd_date_requested wsh_delivery_details.date_requested%TYPE,
31: wdd_date_scheduled wsh_delivery_details.date_scheduled%TYPE,
32: wdd_ship_to_contact_id wsh_delivery_details.ship_to_contact_id%TYPE,

Line 29: wdd_ship_set_id wsh_delivery_details.ship_set_id%TYPE,

25: wdd_source_line_id wsh_delivery_details.source_line_id%TYPE,
26: wdd_source_header_id wsh_delivery_details.source_header_id%TYPE,
27: wdd_oe_interfaced_flag wsh_delivery_details.oe_interfaced_flag%TYPE,
28: wdd_inv_interfaced_flag wsh_delivery_details.inv_interfaced_flag%TYPE,
29: wdd_ship_set_id wsh_delivery_details.ship_set_id%TYPE,
30: wdd_date_requested wsh_delivery_details.date_requested%TYPE,
31: wdd_date_scheduled wsh_delivery_details.date_scheduled%TYPE,
32: wdd_ship_to_contact_id wsh_delivery_details.ship_to_contact_id%TYPE,
33: wdd_ship_to_site_use_id wsh_delivery_details.ship_to_site_use_id%TYPE,

Line 30: wdd_date_requested wsh_delivery_details.date_requested%TYPE,

26: wdd_source_header_id wsh_delivery_details.source_header_id%TYPE,
27: wdd_oe_interfaced_flag wsh_delivery_details.oe_interfaced_flag%TYPE,
28: wdd_inv_interfaced_flag wsh_delivery_details.inv_interfaced_flag%TYPE,
29: wdd_ship_set_id wsh_delivery_details.ship_set_id%TYPE,
30: wdd_date_requested wsh_delivery_details.date_requested%TYPE,
31: wdd_date_scheduled wsh_delivery_details.date_scheduled%TYPE,
32: wdd_ship_to_contact_id wsh_delivery_details.ship_to_contact_id%TYPE,
33: wdd_ship_to_site_use_id wsh_delivery_details.ship_to_site_use_id%TYPE,
34: wdd_org_id wsh_delivery_details.org_id%TYPE,

Line 31: wdd_date_scheduled wsh_delivery_details.date_scheduled%TYPE,

27: wdd_oe_interfaced_flag wsh_delivery_details.oe_interfaced_flag%TYPE,
28: wdd_inv_interfaced_flag wsh_delivery_details.inv_interfaced_flag%TYPE,
29: wdd_ship_set_id wsh_delivery_details.ship_set_id%TYPE,
30: wdd_date_requested wsh_delivery_details.date_requested%TYPE,
31: wdd_date_scheduled wsh_delivery_details.date_scheduled%TYPE,
32: wdd_ship_to_contact_id wsh_delivery_details.ship_to_contact_id%TYPE,
33: wdd_ship_to_site_use_id wsh_delivery_details.ship_to_site_use_id%TYPE,
34: wdd_org_id wsh_delivery_details.org_id%TYPE,
35: wdd_organization_id wsh_delivery_details.organization_id%TYPE,

Line 32: wdd_ship_to_contact_id wsh_delivery_details.ship_to_contact_id%TYPE,

28: wdd_inv_interfaced_flag wsh_delivery_details.inv_interfaced_flag%TYPE,
29: wdd_ship_set_id wsh_delivery_details.ship_set_id%TYPE,
30: wdd_date_requested wsh_delivery_details.date_requested%TYPE,
31: wdd_date_scheduled wsh_delivery_details.date_scheduled%TYPE,
32: wdd_ship_to_contact_id wsh_delivery_details.ship_to_contact_id%TYPE,
33: wdd_ship_to_site_use_id wsh_delivery_details.ship_to_site_use_id%TYPE,
34: wdd_org_id wsh_delivery_details.org_id%TYPE,
35: wdd_organization_id wsh_delivery_details.organization_id%TYPE,
36: wdd_ship_tolerance_above wsh_delivery_details.ship_tolerance_above%TYPE,

Line 33: wdd_ship_to_site_use_id wsh_delivery_details.ship_to_site_use_id%TYPE,

29: wdd_ship_set_id wsh_delivery_details.ship_set_id%TYPE,
30: wdd_date_requested wsh_delivery_details.date_requested%TYPE,
31: wdd_date_scheduled wsh_delivery_details.date_scheduled%TYPE,
32: wdd_ship_to_contact_id wsh_delivery_details.ship_to_contact_id%TYPE,
33: wdd_ship_to_site_use_id wsh_delivery_details.ship_to_site_use_id%TYPE,
34: wdd_org_id wsh_delivery_details.org_id%TYPE,
35: wdd_organization_id wsh_delivery_details.organization_id%TYPE,
36: wdd_ship_tolerance_above wsh_delivery_details.ship_tolerance_above%TYPE,
37: wdd_ship_tolerance_below wsh_delivery_details.ship_tolerance_below%TYPE,

Line 34: wdd_org_id wsh_delivery_details.org_id%TYPE,

30: wdd_date_requested wsh_delivery_details.date_requested%TYPE,
31: wdd_date_scheduled wsh_delivery_details.date_scheduled%TYPE,
32: wdd_ship_to_contact_id wsh_delivery_details.ship_to_contact_id%TYPE,
33: wdd_ship_to_site_use_id wsh_delivery_details.ship_to_site_use_id%TYPE,
34: wdd_org_id wsh_delivery_details.org_id%TYPE,
35: wdd_organization_id wsh_delivery_details.organization_id%TYPE,
36: wdd_ship_tolerance_above wsh_delivery_details.ship_tolerance_above%TYPE,
37: wdd_ship_tolerance_below wsh_delivery_details.ship_tolerance_below%TYPE,
38: wdd_picked_quantity wsh_delivery_details.picked_quantity%TYPE,

Line 35: wdd_organization_id wsh_delivery_details.organization_id%TYPE,

31: wdd_date_scheduled wsh_delivery_details.date_scheduled%TYPE,
32: wdd_ship_to_contact_id wsh_delivery_details.ship_to_contact_id%TYPE,
33: wdd_ship_to_site_use_id wsh_delivery_details.ship_to_site_use_id%TYPE,
34: wdd_org_id wsh_delivery_details.org_id%TYPE,
35: wdd_organization_id wsh_delivery_details.organization_id%TYPE,
36: wdd_ship_tolerance_above wsh_delivery_details.ship_tolerance_above%TYPE,
37: wdd_ship_tolerance_below wsh_delivery_details.ship_tolerance_below%TYPE,
38: wdd_picked_quantity wsh_delivery_details.picked_quantity%TYPE,
39: wdd_cycle_count_quantity wsh_delivery_details.cycle_count_quantity%TYPE,

Line 36: wdd_ship_tolerance_above wsh_delivery_details.ship_tolerance_above%TYPE,

32: wdd_ship_to_contact_id wsh_delivery_details.ship_to_contact_id%TYPE,
33: wdd_ship_to_site_use_id wsh_delivery_details.ship_to_site_use_id%TYPE,
34: wdd_org_id wsh_delivery_details.org_id%TYPE,
35: wdd_organization_id wsh_delivery_details.organization_id%TYPE,
36: wdd_ship_tolerance_above wsh_delivery_details.ship_tolerance_above%TYPE,
37: wdd_ship_tolerance_below wsh_delivery_details.ship_tolerance_below%TYPE,
38: wdd_picked_quantity wsh_delivery_details.picked_quantity%TYPE,
39: wdd_cycle_count_quantity wsh_delivery_details.cycle_count_quantity%TYPE,
40: wdd_shipped_quantity wsh_delivery_details.shipped_quantity%TYPE,

Line 37: wdd_ship_tolerance_below wsh_delivery_details.ship_tolerance_below%TYPE,

33: wdd_ship_to_site_use_id wsh_delivery_details.ship_to_site_use_id%TYPE,
34: wdd_org_id wsh_delivery_details.org_id%TYPE,
35: wdd_organization_id wsh_delivery_details.organization_id%TYPE,
36: wdd_ship_tolerance_above wsh_delivery_details.ship_tolerance_above%TYPE,
37: wdd_ship_tolerance_below wsh_delivery_details.ship_tolerance_below%TYPE,
38: wdd_picked_quantity wsh_delivery_details.picked_quantity%TYPE,
39: wdd_cycle_count_quantity wsh_delivery_details.cycle_count_quantity%TYPE,
40: wdd_shipped_quantity wsh_delivery_details.shipped_quantity%TYPE,
41: ol_line_id oe_order_lines_all.line_id%TYPE,

Line 38: wdd_picked_quantity wsh_delivery_details.picked_quantity%TYPE,

34: wdd_org_id wsh_delivery_details.org_id%TYPE,
35: wdd_organization_id wsh_delivery_details.organization_id%TYPE,
36: wdd_ship_tolerance_above wsh_delivery_details.ship_tolerance_above%TYPE,
37: wdd_ship_tolerance_below wsh_delivery_details.ship_tolerance_below%TYPE,
38: wdd_picked_quantity wsh_delivery_details.picked_quantity%TYPE,
39: wdd_cycle_count_quantity wsh_delivery_details.cycle_count_quantity%TYPE,
40: wdd_shipped_quantity wsh_delivery_details.shipped_quantity%TYPE,
41: ol_line_id oe_order_lines_all.line_id%TYPE,
42: --Line number here is a concatenation of five different numbers

Line 39: wdd_cycle_count_quantity wsh_delivery_details.cycle_count_quantity%TYPE,

35: wdd_organization_id wsh_delivery_details.organization_id%TYPE,
36: wdd_ship_tolerance_above wsh_delivery_details.ship_tolerance_above%TYPE,
37: wdd_ship_tolerance_below wsh_delivery_details.ship_tolerance_below%TYPE,
38: wdd_picked_quantity wsh_delivery_details.picked_quantity%TYPE,
39: wdd_cycle_count_quantity wsh_delivery_details.cycle_count_quantity%TYPE,
40: wdd_shipped_quantity wsh_delivery_details.shipped_quantity%TYPE,
41: ol_line_id oe_order_lines_all.line_id%TYPE,
42: --Line number here is a concatenation of five different numbers
43: ol_line_number VARCHAR2(32767),

Line 40: wdd_shipped_quantity wsh_delivery_details.shipped_quantity%TYPE,

36: wdd_ship_tolerance_above wsh_delivery_details.ship_tolerance_above%TYPE,
37: wdd_ship_tolerance_below wsh_delivery_details.ship_tolerance_below%TYPE,
38: wdd_picked_quantity wsh_delivery_details.picked_quantity%TYPE,
39: wdd_cycle_count_quantity wsh_delivery_details.cycle_count_quantity%TYPE,
40: wdd_shipped_quantity wsh_delivery_details.shipped_quantity%TYPE,
41: ol_line_id oe_order_lines_all.line_id%TYPE,
42: --Line number here is a concatenation of five different numbers
43: ol_line_number VARCHAR2(32767),
44: ol_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE,