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

Line 1: PACKAGE WSH_DELIVERY_DETAILS_ACTIONS as

1: PACKAGE WSH_DELIVERY_DETAILS_ACTIONS as
2: /* $Header: WSHDDACS.pls 120.4.12010000.1 2008/07/29 05:59:24 appldev ship $ */
3:
4:
5: -- for splitting records

Line 53: FROM wsh_delivery_details wdd,

49: NVL(wv_frozen_flag,'Y'),
50: wda.parent_delivery_id,
51: NVL(wda.type, 'S'),
52: replenishment_status --bug# 6689448 (replenishment project)
53: FROM wsh_delivery_details wdd,
54: wsh_delivery_assignments wda
55: WHERE wdd.delivery_detail_id = x_delivery_detail_id
56: AND wda.delivery_detail_id = wdd.delivery_detail_id
57: AND NVL(wda.type, 'S') in ('S', 'C');

Line 61: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE,

57: AND NVL(wda.type, 'S') in ('S', 'C');
58:
59:
60: TYPE SplitDetailRecType IS RECORD (
61: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE,
62: requested_quantity WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
63: picked_quantity WSH_DELIVERY_DETAILS.picked_quantity%TYPE,
64: shipped_quantity WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
65: cycle_count_quantity WSH_DELIVERY_DETAILS.cycle_count_quantity%TYPE,

Line 62: requested_quantity WSH_DELIVERY_DETAILS.requested_quantity%TYPE,

58:
59:
60: TYPE SplitDetailRecType IS RECORD (
61: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE,
62: requested_quantity WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
63: picked_quantity WSH_DELIVERY_DETAILS.picked_quantity%TYPE,
64: shipped_quantity WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
65: cycle_count_quantity WSH_DELIVERY_DETAILS.cycle_count_quantity%TYPE,
66: requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,

Line 63: picked_quantity WSH_DELIVERY_DETAILS.picked_quantity%TYPE,

59:
60: TYPE SplitDetailRecType IS RECORD (
61: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE,
62: requested_quantity WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
63: picked_quantity WSH_DELIVERY_DETAILS.picked_quantity%TYPE,
64: shipped_quantity WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
65: cycle_count_quantity WSH_DELIVERY_DETAILS.cycle_count_quantity%TYPE,
66: requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
67: requested_quantity2 WSH_DELIVERY_DETAILS.requested_quantity2%TYPE,

Line 64: shipped_quantity WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,

60: TYPE SplitDetailRecType IS RECORD (
61: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE,
62: requested_quantity WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
63: picked_quantity WSH_DELIVERY_DETAILS.picked_quantity%TYPE,
64: shipped_quantity WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
65: cycle_count_quantity WSH_DELIVERY_DETAILS.cycle_count_quantity%TYPE,
66: requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
67: requested_quantity2 WSH_DELIVERY_DETAILS.requested_quantity2%TYPE,
68: picked_quantity2 WSH_DELIVERY_DETAILS.picked_quantity2%TYPE,

Line 65: cycle_count_quantity WSH_DELIVERY_DETAILS.cycle_count_quantity%TYPE,

61: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE,
62: requested_quantity WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
63: picked_quantity WSH_DELIVERY_DETAILS.picked_quantity%TYPE,
64: shipped_quantity WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
65: cycle_count_quantity WSH_DELIVERY_DETAILS.cycle_count_quantity%TYPE,
66: requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
67: requested_quantity2 WSH_DELIVERY_DETAILS.requested_quantity2%TYPE,
68: picked_quantity2 WSH_DELIVERY_DETAILS.picked_quantity2%TYPE,
69: shipped_quantity2 WSH_DELIVERY_DETAILS.shipped_quantity2%TYPE,

Line 66: requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,

62: requested_quantity WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
63: picked_quantity WSH_DELIVERY_DETAILS.picked_quantity%TYPE,
64: shipped_quantity WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
65: cycle_count_quantity WSH_DELIVERY_DETAILS.cycle_count_quantity%TYPE,
66: requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
67: requested_quantity2 WSH_DELIVERY_DETAILS.requested_quantity2%TYPE,
68: picked_quantity2 WSH_DELIVERY_DETAILS.picked_quantity2%TYPE,
69: shipped_quantity2 WSH_DELIVERY_DETAILS.shipped_quantity2%TYPE,
70: cycle_count_quantity2 WSH_DELIVERY_DETAILS.cycle_count_quantity2%TYPE,

Line 67: requested_quantity2 WSH_DELIVERY_DETAILS.requested_quantity2%TYPE,

63: picked_quantity WSH_DELIVERY_DETAILS.picked_quantity%TYPE,
64: shipped_quantity WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
65: cycle_count_quantity WSH_DELIVERY_DETAILS.cycle_count_quantity%TYPE,
66: requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
67: requested_quantity2 WSH_DELIVERY_DETAILS.requested_quantity2%TYPE,
68: picked_quantity2 WSH_DELIVERY_DETAILS.picked_quantity2%TYPE,
69: shipped_quantity2 WSH_DELIVERY_DETAILS.shipped_quantity2%TYPE,
70: cycle_count_quantity2 WSH_DELIVERY_DETAILS.cycle_count_quantity2%TYPE,
71: requested_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE,

Line 68: picked_quantity2 WSH_DELIVERY_DETAILS.picked_quantity2%TYPE,

64: shipped_quantity WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
65: cycle_count_quantity WSH_DELIVERY_DETAILS.cycle_count_quantity%TYPE,
66: requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
67: requested_quantity2 WSH_DELIVERY_DETAILS.requested_quantity2%TYPE,
68: picked_quantity2 WSH_DELIVERY_DETAILS.picked_quantity2%TYPE,
69: shipped_quantity2 WSH_DELIVERY_DETAILS.shipped_quantity2%TYPE,
70: cycle_count_quantity2 WSH_DELIVERY_DETAILS.cycle_count_quantity2%TYPE,
71: requested_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE,
72: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,

Line 69: shipped_quantity2 WSH_DELIVERY_DETAILS.shipped_quantity2%TYPE,

65: cycle_count_quantity WSH_DELIVERY_DETAILS.cycle_count_quantity%TYPE,
66: requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
67: requested_quantity2 WSH_DELIVERY_DETAILS.requested_quantity2%TYPE,
68: picked_quantity2 WSH_DELIVERY_DETAILS.picked_quantity2%TYPE,
69: shipped_quantity2 WSH_DELIVERY_DETAILS.shipped_quantity2%TYPE,
70: cycle_count_quantity2 WSH_DELIVERY_DETAILS.cycle_count_quantity2%TYPE,
71: requested_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE,
72: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
73: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,

Line 70: cycle_count_quantity2 WSH_DELIVERY_DETAILS.cycle_count_quantity2%TYPE,

66: requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
67: requested_quantity2 WSH_DELIVERY_DETAILS.requested_quantity2%TYPE,
68: picked_quantity2 WSH_DELIVERY_DETAILS.picked_quantity2%TYPE,
69: shipped_quantity2 WSH_DELIVERY_DETAILS.shipped_quantity2%TYPE,
70: cycle_count_quantity2 WSH_DELIVERY_DETAILS.cycle_count_quantity2%TYPE,
71: requested_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE,
72: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
73: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
74: subinventory WSH_DELIVERY_DETAILS.subinventory%TYPE,

Line 71: requested_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE,

67: requested_quantity2 WSH_DELIVERY_DETAILS.requested_quantity2%TYPE,
68: picked_quantity2 WSH_DELIVERY_DETAILS.picked_quantity2%TYPE,
69: shipped_quantity2 WSH_DELIVERY_DETAILS.shipped_quantity2%TYPE,
70: cycle_count_quantity2 WSH_DELIVERY_DETAILS.cycle_count_quantity2%TYPE,
71: requested_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE,
72: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
73: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
74: subinventory WSH_DELIVERY_DETAILS.subinventory%TYPE,
75: lot_number WSH_DELIVERY_DETAILS.lot_number%TYPE,

Line 72: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,

68: picked_quantity2 WSH_DELIVERY_DETAILS.picked_quantity2%TYPE,
69: shipped_quantity2 WSH_DELIVERY_DETAILS.shipped_quantity2%TYPE,
70: cycle_count_quantity2 WSH_DELIVERY_DETAILS.cycle_count_quantity2%TYPE,
71: requested_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE,
72: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
73: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
74: subinventory WSH_DELIVERY_DETAILS.subinventory%TYPE,
75: lot_number WSH_DELIVERY_DETAILS.lot_number%TYPE,
76: -- HW OPMCONV. No need for sublot anymore

Line 73: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,

69: shipped_quantity2 WSH_DELIVERY_DETAILS.shipped_quantity2%TYPE,
70: cycle_count_quantity2 WSH_DELIVERY_DETAILS.cycle_count_quantity2%TYPE,
71: requested_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE,
72: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
73: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
74: subinventory WSH_DELIVERY_DETAILS.subinventory%TYPE,
75: lot_number WSH_DELIVERY_DETAILS.lot_number%TYPE,
76: -- HW OPMCONV. No need for sublot anymore
77: -- sublot_number WSH_DELIVERY_DETAILS.sublot_number%TYPE,

Line 74: subinventory WSH_DELIVERY_DETAILS.subinventory%TYPE,

70: cycle_count_quantity2 WSH_DELIVERY_DETAILS.cycle_count_quantity2%TYPE,
71: requested_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE,
72: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
73: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
74: subinventory WSH_DELIVERY_DETAILS.subinventory%TYPE,
75: lot_number WSH_DELIVERY_DETAILS.lot_number%TYPE,
76: -- HW OPMCONV. No need for sublot anymore
77: -- sublot_number WSH_DELIVERY_DETAILS.sublot_number%TYPE,
78: locator_id WSH_DELIVERY_DETAILS.locator_id%TYPE,

Line 75: lot_number WSH_DELIVERY_DETAILS.lot_number%TYPE,

71: requested_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE,
72: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
73: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
74: subinventory WSH_DELIVERY_DETAILS.subinventory%TYPE,
75: lot_number WSH_DELIVERY_DETAILS.lot_number%TYPE,
76: -- HW OPMCONV. No need for sublot anymore
77: -- sublot_number WSH_DELIVERY_DETAILS.sublot_number%TYPE,
78: locator_id WSH_DELIVERY_DETAILS.locator_id%TYPE,
79: source_line_id WSH_DELIVERY_DETAILS.source_line_id%TYPE,

Line 77: -- sublot_number WSH_DELIVERY_DETAILS.sublot_number%TYPE,

73: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
74: subinventory WSH_DELIVERY_DETAILS.subinventory%TYPE,
75: lot_number WSH_DELIVERY_DETAILS.lot_number%TYPE,
76: -- HW OPMCONV. No need for sublot anymore
77: -- sublot_number WSH_DELIVERY_DETAILS.sublot_number%TYPE,
78: locator_id WSH_DELIVERY_DETAILS.locator_id%TYPE,
79: source_line_id WSH_DELIVERY_DETAILS.source_line_id%TYPE,
80: net_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
81: volume WSH_DELIVERY_DETAILS.volume%TYPE,

Line 78: locator_id WSH_DELIVERY_DETAILS.locator_id%TYPE,

74: subinventory WSH_DELIVERY_DETAILS.subinventory%TYPE,
75: lot_number WSH_DELIVERY_DETAILS.lot_number%TYPE,
76: -- HW OPMCONV. No need for sublot anymore
77: -- sublot_number WSH_DELIVERY_DETAILS.sublot_number%TYPE,
78: locator_id WSH_DELIVERY_DETAILS.locator_id%TYPE,
79: source_line_id WSH_DELIVERY_DETAILS.source_line_id%TYPE,
80: net_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
81: volume WSH_DELIVERY_DETAILS.volume%TYPE,
82: weight_uom_code WSH_DELIVERY_DETAILS.weight_uom_code%TYPE,

Line 79: source_line_id WSH_DELIVERY_DETAILS.source_line_id%TYPE,

75: lot_number WSH_DELIVERY_DETAILS.lot_number%TYPE,
76: -- HW OPMCONV. No need for sublot anymore
77: -- sublot_number WSH_DELIVERY_DETAILS.sublot_number%TYPE,
78: locator_id WSH_DELIVERY_DETAILS.locator_id%TYPE,
79: source_line_id WSH_DELIVERY_DETAILS.source_line_id%TYPE,
80: net_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
81: volume WSH_DELIVERY_DETAILS.volume%TYPE,
82: weight_uom_code WSH_DELIVERY_DETAILS.weight_uom_code%TYPE,
83: volume_uom_code WSH_DELIVERY_DETAILS.volume_uom_code%TYPE,

Line 80: net_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,

76: -- HW OPMCONV. No need for sublot anymore
77: -- sublot_number WSH_DELIVERY_DETAILS.sublot_number%TYPE,
78: locator_id WSH_DELIVERY_DETAILS.locator_id%TYPE,
79: source_line_id WSH_DELIVERY_DETAILS.source_line_id%TYPE,
80: net_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
81: volume WSH_DELIVERY_DETAILS.volume%TYPE,
82: weight_uom_code WSH_DELIVERY_DETAILS.weight_uom_code%TYPE,
83: volume_uom_code WSH_DELIVERY_DETAILS.volume_uom_code%TYPE,
84: cancelled_quantity WSH_DELIVERY_DETAILS.cancelled_quantity%TYPE,

Line 81: volume WSH_DELIVERY_DETAILS.volume%TYPE,

77: -- sublot_number WSH_DELIVERY_DETAILS.sublot_number%TYPE,
78: locator_id WSH_DELIVERY_DETAILS.locator_id%TYPE,
79: source_line_id WSH_DELIVERY_DETAILS.source_line_id%TYPE,
80: net_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
81: volume WSH_DELIVERY_DETAILS.volume%TYPE,
82: weight_uom_code WSH_DELIVERY_DETAILS.weight_uom_code%TYPE,
83: volume_uom_code WSH_DELIVERY_DETAILS.volume_uom_code%TYPE,
84: cancelled_quantity WSH_DELIVERY_DETAILS.cancelled_quantity%TYPE,
85: cancelled_quantity2 WSH_DELIVERY_DETAILS.cancelled_quantity2%TYPE,

Line 82: weight_uom_code WSH_DELIVERY_DETAILS.weight_uom_code%TYPE,

78: locator_id WSH_DELIVERY_DETAILS.locator_id%TYPE,
79: source_line_id WSH_DELIVERY_DETAILS.source_line_id%TYPE,
80: net_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
81: volume WSH_DELIVERY_DETAILS.volume%TYPE,
82: weight_uom_code WSH_DELIVERY_DETAILS.weight_uom_code%TYPE,
83: volume_uom_code WSH_DELIVERY_DETAILS.volume_uom_code%TYPE,
84: cancelled_quantity WSH_DELIVERY_DETAILS.cancelled_quantity%TYPE,
85: cancelled_quantity2 WSH_DELIVERY_DETAILS.cancelled_quantity2%TYPE,
86: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,

Line 83: volume_uom_code WSH_DELIVERY_DETAILS.volume_uom_code%TYPE,

79: source_line_id WSH_DELIVERY_DETAILS.source_line_id%TYPE,
80: net_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
81: volume WSH_DELIVERY_DETAILS.volume%TYPE,
82: weight_uom_code WSH_DELIVERY_DETAILS.weight_uom_code%TYPE,
83: volume_uom_code WSH_DELIVERY_DETAILS.volume_uom_code%TYPE,
84: cancelled_quantity WSH_DELIVERY_DETAILS.cancelled_quantity%TYPE,
85: cancelled_quantity2 WSH_DELIVERY_DETAILS.cancelled_quantity2%TYPE,
86: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
87: to_serial_number WSH_DELIVERY_DETAILS.to_serial_number%TYPE,

Line 84: cancelled_quantity WSH_DELIVERY_DETAILS.cancelled_quantity%TYPE,

80: net_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
81: volume WSH_DELIVERY_DETAILS.volume%TYPE,
82: weight_uom_code WSH_DELIVERY_DETAILS.weight_uom_code%TYPE,
83: volume_uom_code WSH_DELIVERY_DETAILS.volume_uom_code%TYPE,
84: cancelled_quantity WSH_DELIVERY_DETAILS.cancelled_quantity%TYPE,
85: cancelled_quantity2 WSH_DELIVERY_DETAILS.cancelled_quantity2%TYPE,
86: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
87: to_serial_number WSH_DELIVERY_DETAILS.to_serial_number%TYPE,
88: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,

Line 85: cancelled_quantity2 WSH_DELIVERY_DETAILS.cancelled_quantity2%TYPE,

81: volume WSH_DELIVERY_DETAILS.volume%TYPE,
82: weight_uom_code WSH_DELIVERY_DETAILS.weight_uom_code%TYPE,
83: volume_uom_code WSH_DELIVERY_DETAILS.volume_uom_code%TYPE,
84: cancelled_quantity WSH_DELIVERY_DETAILS.cancelled_quantity%TYPE,
85: cancelled_quantity2 WSH_DELIVERY_DETAILS.cancelled_quantity2%TYPE,
86: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
87: to_serial_number WSH_DELIVERY_DETAILS.to_serial_number%TYPE,
88: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,
89: container_flag WSH_DELIVERY_DETAILS.container_flag%TYPE,

Line 86: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,

82: weight_uom_code WSH_DELIVERY_DETAILS.weight_uom_code%TYPE,
83: volume_uom_code WSH_DELIVERY_DETAILS.volume_uom_code%TYPE,
84: cancelled_quantity WSH_DELIVERY_DETAILS.cancelled_quantity%TYPE,
85: cancelled_quantity2 WSH_DELIVERY_DETAILS.cancelled_quantity2%TYPE,
86: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
87: to_serial_number WSH_DELIVERY_DETAILS.to_serial_number%TYPE,
88: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,
89: container_flag WSH_DELIVERY_DETAILS.container_flag%TYPE,
90: released_status WSH_DELIVERY_DETAILS.released_status%TYPE,

Line 87: to_serial_number WSH_DELIVERY_DETAILS.to_serial_number%TYPE,

83: volume_uom_code WSH_DELIVERY_DETAILS.volume_uom_code%TYPE,
84: cancelled_quantity WSH_DELIVERY_DETAILS.cancelled_quantity%TYPE,
85: cancelled_quantity2 WSH_DELIVERY_DETAILS.cancelled_quantity2%TYPE,
86: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
87: to_serial_number WSH_DELIVERY_DETAILS.to_serial_number%TYPE,
88: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,
89: container_flag WSH_DELIVERY_DETAILS.container_flag%TYPE,
90: released_status WSH_DELIVERY_DETAILS.released_status%TYPE,
91: delivery_id wsh_delivery_assignments_v.delivery_id%TYPE,

Line 88: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,

84: cancelled_quantity WSH_DELIVERY_DETAILS.cancelled_quantity%TYPE,
85: cancelled_quantity2 WSH_DELIVERY_DETAILS.cancelled_quantity2%TYPE,
86: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
87: to_serial_number WSH_DELIVERY_DETAILS.to_serial_number%TYPE,
88: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,
89: container_flag WSH_DELIVERY_DETAILS.container_flag%TYPE,
90: released_status WSH_DELIVERY_DETAILS.released_status%TYPE,
91: delivery_id wsh_delivery_assignments_v.delivery_id%TYPE,
92: parent_delivery_detail_id wsh_delivery_assignments_v.parent_delivery_detail_id%TYPE,

Line 89: container_flag WSH_DELIVERY_DETAILS.container_flag%TYPE,

85: cancelled_quantity2 WSH_DELIVERY_DETAILS.cancelled_quantity2%TYPE,
86: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
87: to_serial_number WSH_DELIVERY_DETAILS.to_serial_number%TYPE,
88: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,
89: container_flag WSH_DELIVERY_DETAILS.container_flag%TYPE,
90: released_status WSH_DELIVERY_DETAILS.released_status%TYPE,
91: delivery_id wsh_delivery_assignments_v.delivery_id%TYPE,
92: parent_delivery_detail_id wsh_delivery_assignments_v.parent_delivery_detail_id%TYPE,
93: -- Bug 2419301

Line 90: released_status WSH_DELIVERY_DETAILS.released_status%TYPE,

86: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
87: to_serial_number WSH_DELIVERY_DETAILS.to_serial_number%TYPE,
88: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,
89: container_flag WSH_DELIVERY_DETAILS.container_flag%TYPE,
90: released_status WSH_DELIVERY_DETAILS.released_status%TYPE,
91: delivery_id wsh_delivery_assignments_v.delivery_id%TYPE,
92: parent_delivery_detail_id wsh_delivery_assignments_v.parent_delivery_detail_id%TYPE,
93: -- Bug 2419301
94: oe_interfaced_flag WSH_DELIVERY_DETAILS.oe_interfaced_flag%TYPE,

Line 94: oe_interfaced_flag WSH_DELIVERY_DETAILS.oe_interfaced_flag%TYPE,

90: released_status WSH_DELIVERY_DETAILS.released_status%TYPE,
91: delivery_id wsh_delivery_assignments_v.delivery_id%TYPE,
92: parent_delivery_detail_id wsh_delivery_assignments_v.parent_delivery_detail_id%TYPE,
93: -- Bug 2419301
94: oe_interfaced_flag WSH_DELIVERY_DETAILS.oe_interfaced_flag%TYPE,
95: -- anxsharm bug 2181132
96: source_line_set_id WSH_DELIVERY_DETAILS.source_line_set_id%TYPE,
97: received_quantity WSH_DELIVERY_DETAILS.received_quantity%TYPE,-- J-IB-NPARIKH
98: received_quantity2 WSH_DELIVERY_DETAILS.received_quantity2%TYPE,-- J-IB-NPARIKH

Line 96: source_line_set_id WSH_DELIVERY_DETAILS.source_line_set_id%TYPE,

92: parent_delivery_detail_id wsh_delivery_assignments_v.parent_delivery_detail_id%TYPE,
93: -- Bug 2419301
94: oe_interfaced_flag WSH_DELIVERY_DETAILS.oe_interfaced_flag%TYPE,
95: -- anxsharm bug 2181132
96: source_line_set_id WSH_DELIVERY_DETAILS.source_line_set_id%TYPE,
97: received_quantity WSH_DELIVERY_DETAILS.received_quantity%TYPE,-- J-IB-NPARIKH
98: received_quantity2 WSH_DELIVERY_DETAILS.received_quantity2%TYPE,-- J-IB-NPARIKH
99: returned_quantity WSH_DELIVERY_DETAILS.returned_quantity%TYPE,-- J-IB-NPARIKH
100: returned_quantity2 WSH_DELIVERY_DETAILS.returned_quantity2%TYPE,-- J-IB-NPARIKH

Line 97: received_quantity WSH_DELIVERY_DETAILS.received_quantity%TYPE,-- J-IB-NPARIKH

93: -- Bug 2419301
94: oe_interfaced_flag WSH_DELIVERY_DETAILS.oe_interfaced_flag%TYPE,
95: -- anxsharm bug 2181132
96: source_line_set_id WSH_DELIVERY_DETAILS.source_line_set_id%TYPE,
97: received_quantity WSH_DELIVERY_DETAILS.received_quantity%TYPE,-- J-IB-NPARIKH
98: received_quantity2 WSH_DELIVERY_DETAILS.received_quantity2%TYPE,-- J-IB-NPARIKH
99: returned_quantity WSH_DELIVERY_DETAILS.returned_quantity%TYPE,-- J-IB-NPARIKH
100: returned_quantity2 WSH_DELIVERY_DETAILS.returned_quantity2%TYPE,-- J-IB-NPARIKH
101: line_direction WSH_DELIVERY_DETAILS.line_direction%TYPE,-- J-IB-NPARIKH

Line 98: received_quantity2 WSH_DELIVERY_DETAILS.received_quantity2%TYPE,-- J-IB-NPARIKH

94: oe_interfaced_flag WSH_DELIVERY_DETAILS.oe_interfaced_flag%TYPE,
95: -- anxsharm bug 2181132
96: source_line_set_id WSH_DELIVERY_DETAILS.source_line_set_id%TYPE,
97: received_quantity WSH_DELIVERY_DETAILS.received_quantity%TYPE,-- J-IB-NPARIKH
98: received_quantity2 WSH_DELIVERY_DETAILS.received_quantity2%TYPE,-- J-IB-NPARIKH
99: returned_quantity WSH_DELIVERY_DETAILS.returned_quantity%TYPE,-- J-IB-NPARIKH
100: returned_quantity2 WSH_DELIVERY_DETAILS.returned_quantity2%TYPE,-- J-IB-NPARIKH
101: line_direction WSH_DELIVERY_DETAILS.line_direction%TYPE,-- J-IB-NPARIKH
102: -- J: W/V Changes

Line 99: returned_quantity WSH_DELIVERY_DETAILS.returned_quantity%TYPE,-- J-IB-NPARIKH

95: -- anxsharm bug 2181132
96: source_line_set_id WSH_DELIVERY_DETAILS.source_line_set_id%TYPE,
97: received_quantity WSH_DELIVERY_DETAILS.received_quantity%TYPE,-- J-IB-NPARIKH
98: received_quantity2 WSH_DELIVERY_DETAILS.received_quantity2%TYPE,-- J-IB-NPARIKH
99: returned_quantity WSH_DELIVERY_DETAILS.returned_quantity%TYPE,-- J-IB-NPARIKH
100: returned_quantity2 WSH_DELIVERY_DETAILS.returned_quantity2%TYPE,-- J-IB-NPARIKH
101: line_direction WSH_DELIVERY_DETAILS.line_direction%TYPE,-- J-IB-NPARIKH
102: -- J: W/V Changes
103: gross_weight WSH_DELIVERY_DETAILS.gross_weight%TYPE,

Line 100: returned_quantity2 WSH_DELIVERY_DETAILS.returned_quantity2%TYPE,-- J-IB-NPARIKH

96: source_line_set_id WSH_DELIVERY_DETAILS.source_line_set_id%TYPE,
97: received_quantity WSH_DELIVERY_DETAILS.received_quantity%TYPE,-- J-IB-NPARIKH
98: received_quantity2 WSH_DELIVERY_DETAILS.received_quantity2%TYPE,-- J-IB-NPARIKH
99: returned_quantity WSH_DELIVERY_DETAILS.returned_quantity%TYPE,-- J-IB-NPARIKH
100: returned_quantity2 WSH_DELIVERY_DETAILS.returned_quantity2%TYPE,-- J-IB-NPARIKH
101: line_direction WSH_DELIVERY_DETAILS.line_direction%TYPE,-- J-IB-NPARIKH
102: -- J: W/V Changes
103: gross_weight WSH_DELIVERY_DETAILS.gross_weight%TYPE,
104: wv_frozen_flag WSH_DELIVERY_DETAILS.wv_frozen_flag%TYPE,

Line 101: line_direction WSH_DELIVERY_DETAILS.line_direction%TYPE,-- J-IB-NPARIKH

97: received_quantity WSH_DELIVERY_DETAILS.received_quantity%TYPE,-- J-IB-NPARIKH
98: received_quantity2 WSH_DELIVERY_DETAILS.received_quantity2%TYPE,-- J-IB-NPARIKH
99: returned_quantity WSH_DELIVERY_DETAILS.returned_quantity%TYPE,-- J-IB-NPARIKH
100: returned_quantity2 WSH_DELIVERY_DETAILS.returned_quantity2%TYPE,-- J-IB-NPARIKH
101: line_direction WSH_DELIVERY_DETAILS.line_direction%TYPE,-- J-IB-NPARIKH
102: -- J: W/V Changes
103: gross_weight WSH_DELIVERY_DETAILS.gross_weight%TYPE,
104: wv_frozen_flag WSH_DELIVERY_DETAILS.wv_frozen_flag%TYPE,
105: parent_delivery_id WSH_DELIVERY_ASSIGNMENTS_V.parent_delivery_id%TYPE,

Line 103: gross_weight WSH_DELIVERY_DETAILS.gross_weight%TYPE,

99: returned_quantity WSH_DELIVERY_DETAILS.returned_quantity%TYPE,-- J-IB-NPARIKH
100: returned_quantity2 WSH_DELIVERY_DETAILS.returned_quantity2%TYPE,-- J-IB-NPARIKH
101: line_direction WSH_DELIVERY_DETAILS.line_direction%TYPE,-- J-IB-NPARIKH
102: -- J: W/V Changes
103: gross_weight WSH_DELIVERY_DETAILS.gross_weight%TYPE,
104: wv_frozen_flag WSH_DELIVERY_DETAILS.wv_frozen_flag%TYPE,
105: parent_delivery_id WSH_DELIVERY_ASSIGNMENTS_V.parent_delivery_id%TYPE,
106: wda_type WSH_DELIVERY_ASSIGNMENTS_V.type%TYPE,
107: replenishment_status WSH_DELIVERY_DETAILS.replenishment_status%TYPE --bug# 6689448 (replenishment project)

Line 104: wv_frozen_flag WSH_DELIVERY_DETAILS.wv_frozen_flag%TYPE,

100: returned_quantity2 WSH_DELIVERY_DETAILS.returned_quantity2%TYPE,-- J-IB-NPARIKH
101: line_direction WSH_DELIVERY_DETAILS.line_direction%TYPE,-- J-IB-NPARIKH
102: -- J: W/V Changes
103: gross_weight WSH_DELIVERY_DETAILS.gross_weight%TYPE,
104: wv_frozen_flag WSH_DELIVERY_DETAILS.wv_frozen_flag%TYPE,
105: parent_delivery_id WSH_DELIVERY_ASSIGNMENTS_V.parent_delivery_id%TYPE,
106: wda_type WSH_DELIVERY_ASSIGNMENTS_V.type%TYPE,
107: replenishment_status WSH_DELIVERY_DETAILS.replenishment_status%TYPE --bug# 6689448 (replenishment project)
108: );

Line 107: replenishment_status WSH_DELIVERY_DETAILS.replenishment_status%TYPE --bug# 6689448 (replenishment project)

103: gross_weight WSH_DELIVERY_DETAILS.gross_weight%TYPE,
104: wv_frozen_flag WSH_DELIVERY_DETAILS.wv_frozen_flag%TYPE,
105: parent_delivery_id WSH_DELIVERY_ASSIGNMENTS_V.parent_delivery_id%TYPE,
106: wda_type WSH_DELIVERY_ASSIGNMENTS_V.type%TYPE,
107: replenishment_status WSH_DELIVERY_DETAILS.replenishment_status%TYPE --bug# 6689448 (replenishment project)
108: );
109:
110: -- anxsharm
111: -- for Split Serial Number

Line 113: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,

109:
110: -- anxsharm
111: -- for Split Serial Number
112: TYPE SerialRecType IS RECORD (
113: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
114: to_serial_number WSH_DELIVERY_DETAILS.to_serial_number%TYPE,
115: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,
116: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE);
117:

Line 114: to_serial_number WSH_DELIVERY_DETAILS.to_serial_number%TYPE,

110: -- anxsharm
111: -- for Split Serial Number
112: TYPE SerialRecType IS RECORD (
113: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
114: to_serial_number WSH_DELIVERY_DETAILS.to_serial_number%TYPE,
115: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,
116: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE);
117:
118: TYPE Serial_tab is TABLE of SerialRecType INDEX BY BINARY_INTEGER;

Line 115: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,

111: -- for Split Serial Number
112: TYPE SerialRecType IS RECORD (
113: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
114: to_serial_number WSH_DELIVERY_DETAILS.to_serial_number%TYPE,
115: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,
116: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE);
117:
118: TYPE Serial_tab is TABLE of SerialRecType INDEX BY BINARY_INTEGER;
119: --

Line 116: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE);

112: TYPE SerialRecType IS RECORD (
113: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
114: to_serial_number WSH_DELIVERY_DETAILS.to_serial_number%TYPE,
115: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,
116: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE);
117:
118: TYPE Serial_tab is TABLE of SerialRecType INDEX BY BINARY_INTEGER;
119: --
120: -- PACKAGE VARIABLES

Line 190: wsh_delivery_details wdd

186: wdd.volume_uom_code,
187: wdd.inventory_item_id,
188: wda.type wda_type
189: FROM wsh_delivery_assignments_v wda,
190: wsh_delivery_details wdd
191: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
192: AND wda.delivery_detail_id = c_detail_id;
193:
194: -- Consolidation of Back Order Delivery Details Enhancement

Line 488: p_Cons_Source_Line_Rec_Tab IN WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab,

484: -- into one delivery detail id for the given source line id
485: --
486: --
487: PROCEDURE Consolidate_Source_Line(
488: p_Cons_Source_Line_Rec_Tab IN WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab,
489: x_consolidate_ids OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
490: x_return_status OUT NOCOPY VARCHAR2 );
491:
492:

Line 514: p_delivery_details_tab IN WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab,

510: -- delivery detail for each source line id.
511: --
512: -- HW OPM BUG#:3121616 Added x_remain_bo_qty2s
513: PROCEDURE Consolidate_Delivery_Details(
514: p_delivery_details_tab IN WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab,
515: p_bo_mode IN VARCHAR2,
516: x_cons_delivery_details_tab OUT NOCOPY WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab,
517: x_remain_bo_qtys OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
518: x_remain_bo_qty2s OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,

Line 516: x_cons_delivery_details_tab OUT NOCOPY WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab,

512: -- HW OPM BUG#:3121616 Added x_remain_bo_qty2s
513: PROCEDURE Consolidate_Delivery_Details(
514: p_delivery_details_tab IN WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab,
515: p_bo_mode IN VARCHAR2,
516: x_cons_delivery_details_tab OUT NOCOPY WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab,
517: x_remain_bo_qtys OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
518: x_remain_bo_qty2s OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
519: x_return_status OUT NOCOPY VARCHAR2
520: );

Line 531: END WSH_DELIVERY_DETAILS_ACTIONS;

527: PROCEDURE Delete_Consol_Record(
528: p_detail_id_tab IN wsh_util_core.id_tab_type,
529: x_return_status OUT NOCOPY VARCHAR2);
530:
531: END WSH_DELIVERY_DETAILS_ACTIONS;
532: