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 AUTHID CURRENT_USER as

1: PACKAGE WSH_DELIVERY_DETAILS_ACTIONS AUTHID CURRENT_USER as
2: /* $Header: WSHDDACS.pls 120.8.12020000.6 2013/05/30 13:25:11 skanduku ship $ */
3:
4:
5: -- for splitting records

Line 56: FROM wsh_delivery_details wdd,

52: replenishment_status, --bug# 6689448 (replenishment project)
53: consignee_flag, --RTV changes
54: source_header_id, --RTV changes
55: source_code --RTV changes
56: FROM wsh_delivery_details wdd,
57: wsh_delivery_assignments wda
58: WHERE wdd.delivery_detail_id = x_delivery_detail_id
59: AND wda.delivery_detail_id = wdd.delivery_detail_id
60: AND NVL(wda.type, 'S') in ('S', 'C');

Line 64: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE,

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

Line 65: requested_quantity WSH_DELIVERY_DETAILS.requested_quantity%TYPE,

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

Line 66: picked_quantity WSH_DELIVERY_DETAILS.picked_quantity%TYPE,

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

Line 67: shipped_quantity WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,

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

Line 68: cycle_count_quantity WSH_DELIVERY_DETAILS.cycle_count_quantity%TYPE,

64: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE,
65: requested_quantity WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
66: picked_quantity WSH_DELIVERY_DETAILS.picked_quantity%TYPE,
67: shipped_quantity WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
68: cycle_count_quantity WSH_DELIVERY_DETAILS.cycle_count_quantity%TYPE,
69: requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
70: requested_quantity2 WSH_DELIVERY_DETAILS.requested_quantity2%TYPE,
71: picked_quantity2 WSH_DELIVERY_DETAILS.picked_quantity2%TYPE,
72: shipped_quantity2 WSH_DELIVERY_DETAILS.shipped_quantity2%TYPE,

Line 69: requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,

65: requested_quantity WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
66: picked_quantity WSH_DELIVERY_DETAILS.picked_quantity%TYPE,
67: shipped_quantity WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
68: cycle_count_quantity WSH_DELIVERY_DETAILS.cycle_count_quantity%TYPE,
69: requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
70: requested_quantity2 WSH_DELIVERY_DETAILS.requested_quantity2%TYPE,
71: picked_quantity2 WSH_DELIVERY_DETAILS.picked_quantity2%TYPE,
72: shipped_quantity2 WSH_DELIVERY_DETAILS.shipped_quantity2%TYPE,
73: cycle_count_quantity2 WSH_DELIVERY_DETAILS.cycle_count_quantity2%TYPE,

Line 70: requested_quantity2 WSH_DELIVERY_DETAILS.requested_quantity2%TYPE,

66: picked_quantity WSH_DELIVERY_DETAILS.picked_quantity%TYPE,
67: shipped_quantity WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
68: cycle_count_quantity WSH_DELIVERY_DETAILS.cycle_count_quantity%TYPE,
69: requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
70: requested_quantity2 WSH_DELIVERY_DETAILS.requested_quantity2%TYPE,
71: picked_quantity2 WSH_DELIVERY_DETAILS.picked_quantity2%TYPE,
72: shipped_quantity2 WSH_DELIVERY_DETAILS.shipped_quantity2%TYPE,
73: cycle_count_quantity2 WSH_DELIVERY_DETAILS.cycle_count_quantity2%TYPE,
74: requested_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE,

Line 71: picked_quantity2 WSH_DELIVERY_DETAILS.picked_quantity2%TYPE,

67: shipped_quantity WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
68: cycle_count_quantity WSH_DELIVERY_DETAILS.cycle_count_quantity%TYPE,
69: requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
70: requested_quantity2 WSH_DELIVERY_DETAILS.requested_quantity2%TYPE,
71: picked_quantity2 WSH_DELIVERY_DETAILS.picked_quantity2%TYPE,
72: shipped_quantity2 WSH_DELIVERY_DETAILS.shipped_quantity2%TYPE,
73: cycle_count_quantity2 WSH_DELIVERY_DETAILS.cycle_count_quantity2%TYPE,
74: requested_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE,
75: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,

Line 72: shipped_quantity2 WSH_DELIVERY_DETAILS.shipped_quantity2%TYPE,

68: cycle_count_quantity WSH_DELIVERY_DETAILS.cycle_count_quantity%TYPE,
69: requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
70: requested_quantity2 WSH_DELIVERY_DETAILS.requested_quantity2%TYPE,
71: picked_quantity2 WSH_DELIVERY_DETAILS.picked_quantity2%TYPE,
72: shipped_quantity2 WSH_DELIVERY_DETAILS.shipped_quantity2%TYPE,
73: cycle_count_quantity2 WSH_DELIVERY_DETAILS.cycle_count_quantity2%TYPE,
74: requested_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE,
75: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
76: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,

Line 73: cycle_count_quantity2 WSH_DELIVERY_DETAILS.cycle_count_quantity2%TYPE,

69: requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
70: requested_quantity2 WSH_DELIVERY_DETAILS.requested_quantity2%TYPE,
71: picked_quantity2 WSH_DELIVERY_DETAILS.picked_quantity2%TYPE,
72: shipped_quantity2 WSH_DELIVERY_DETAILS.shipped_quantity2%TYPE,
73: cycle_count_quantity2 WSH_DELIVERY_DETAILS.cycle_count_quantity2%TYPE,
74: requested_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE,
75: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
76: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
77: subinventory WSH_DELIVERY_DETAILS.subinventory%TYPE,

Line 74: requested_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE,

70: requested_quantity2 WSH_DELIVERY_DETAILS.requested_quantity2%TYPE,
71: picked_quantity2 WSH_DELIVERY_DETAILS.picked_quantity2%TYPE,
72: shipped_quantity2 WSH_DELIVERY_DETAILS.shipped_quantity2%TYPE,
73: cycle_count_quantity2 WSH_DELIVERY_DETAILS.cycle_count_quantity2%TYPE,
74: requested_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE,
75: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
76: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
77: subinventory WSH_DELIVERY_DETAILS.subinventory%TYPE,
78: lot_number WSH_DELIVERY_DETAILS.lot_number%TYPE,

Line 75: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,

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

Line 76: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,

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

Line 77: subinventory WSH_DELIVERY_DETAILS.subinventory%TYPE,

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

Line 78: lot_number WSH_DELIVERY_DETAILS.lot_number%TYPE,

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

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

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

Line 81: locator_id WSH_DELIVERY_DETAILS.locator_id%TYPE,

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

Line 82: source_line_id WSH_DELIVERY_DETAILS.source_line_id%TYPE,

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

Line 83: net_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,

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

Line 84: volume WSH_DELIVERY_DETAILS.volume%TYPE,

80: -- sublot_number WSH_DELIVERY_DETAILS.sublot_number%TYPE,
81: locator_id WSH_DELIVERY_DETAILS.locator_id%TYPE,
82: source_line_id WSH_DELIVERY_DETAILS.source_line_id%TYPE,
83: net_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
84: volume WSH_DELIVERY_DETAILS.volume%TYPE,
85: weight_uom_code WSH_DELIVERY_DETAILS.weight_uom_code%TYPE,
86: volume_uom_code WSH_DELIVERY_DETAILS.volume_uom_code%TYPE,
87: cancelled_quantity WSH_DELIVERY_DETAILS.cancelled_quantity%TYPE,
88: cancelled_quantity2 WSH_DELIVERY_DETAILS.cancelled_quantity2%TYPE,

Line 85: weight_uom_code WSH_DELIVERY_DETAILS.weight_uom_code%TYPE,

81: locator_id WSH_DELIVERY_DETAILS.locator_id%TYPE,
82: source_line_id WSH_DELIVERY_DETAILS.source_line_id%TYPE,
83: net_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
84: volume WSH_DELIVERY_DETAILS.volume%TYPE,
85: weight_uom_code WSH_DELIVERY_DETAILS.weight_uom_code%TYPE,
86: volume_uom_code WSH_DELIVERY_DETAILS.volume_uom_code%TYPE,
87: cancelled_quantity WSH_DELIVERY_DETAILS.cancelled_quantity%TYPE,
88: cancelled_quantity2 WSH_DELIVERY_DETAILS.cancelled_quantity2%TYPE,
89: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,

Line 86: volume_uom_code WSH_DELIVERY_DETAILS.volume_uom_code%TYPE,

82: source_line_id WSH_DELIVERY_DETAILS.source_line_id%TYPE,
83: net_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
84: volume WSH_DELIVERY_DETAILS.volume%TYPE,
85: weight_uom_code WSH_DELIVERY_DETAILS.weight_uom_code%TYPE,
86: volume_uom_code WSH_DELIVERY_DETAILS.volume_uom_code%TYPE,
87: cancelled_quantity WSH_DELIVERY_DETAILS.cancelled_quantity%TYPE,
88: cancelled_quantity2 WSH_DELIVERY_DETAILS.cancelled_quantity2%TYPE,
89: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
90: to_serial_number WSH_DELIVERY_DETAILS.to_serial_number%TYPE,

Line 87: cancelled_quantity WSH_DELIVERY_DETAILS.cancelled_quantity%TYPE,

83: net_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
84: volume WSH_DELIVERY_DETAILS.volume%TYPE,
85: weight_uom_code WSH_DELIVERY_DETAILS.weight_uom_code%TYPE,
86: volume_uom_code WSH_DELIVERY_DETAILS.volume_uom_code%TYPE,
87: cancelled_quantity WSH_DELIVERY_DETAILS.cancelled_quantity%TYPE,
88: cancelled_quantity2 WSH_DELIVERY_DETAILS.cancelled_quantity2%TYPE,
89: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
90: to_serial_number WSH_DELIVERY_DETAILS.to_serial_number%TYPE,
91: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,

Line 88: cancelled_quantity2 WSH_DELIVERY_DETAILS.cancelled_quantity2%TYPE,

84: volume WSH_DELIVERY_DETAILS.volume%TYPE,
85: weight_uom_code WSH_DELIVERY_DETAILS.weight_uom_code%TYPE,
86: volume_uom_code WSH_DELIVERY_DETAILS.volume_uom_code%TYPE,
87: cancelled_quantity WSH_DELIVERY_DETAILS.cancelled_quantity%TYPE,
88: cancelled_quantity2 WSH_DELIVERY_DETAILS.cancelled_quantity2%TYPE,
89: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
90: to_serial_number WSH_DELIVERY_DETAILS.to_serial_number%TYPE,
91: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,
92: container_flag WSH_DELIVERY_DETAILS.container_flag%TYPE,

Line 89: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,

85: weight_uom_code WSH_DELIVERY_DETAILS.weight_uom_code%TYPE,
86: volume_uom_code WSH_DELIVERY_DETAILS.volume_uom_code%TYPE,
87: cancelled_quantity WSH_DELIVERY_DETAILS.cancelled_quantity%TYPE,
88: cancelled_quantity2 WSH_DELIVERY_DETAILS.cancelled_quantity2%TYPE,
89: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
90: to_serial_number WSH_DELIVERY_DETAILS.to_serial_number%TYPE,
91: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,
92: container_flag WSH_DELIVERY_DETAILS.container_flag%TYPE,
93: released_status WSH_DELIVERY_DETAILS.released_status%TYPE,

Line 90: to_serial_number WSH_DELIVERY_DETAILS.to_serial_number%TYPE,

86: volume_uom_code WSH_DELIVERY_DETAILS.volume_uom_code%TYPE,
87: cancelled_quantity WSH_DELIVERY_DETAILS.cancelled_quantity%TYPE,
88: cancelled_quantity2 WSH_DELIVERY_DETAILS.cancelled_quantity2%TYPE,
89: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
90: to_serial_number WSH_DELIVERY_DETAILS.to_serial_number%TYPE,
91: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,
92: container_flag WSH_DELIVERY_DETAILS.container_flag%TYPE,
93: released_status WSH_DELIVERY_DETAILS.released_status%TYPE,
94: delivery_id wsh_delivery_assignments_v.delivery_id%TYPE,

Line 91: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,

87: cancelled_quantity WSH_DELIVERY_DETAILS.cancelled_quantity%TYPE,
88: cancelled_quantity2 WSH_DELIVERY_DETAILS.cancelled_quantity2%TYPE,
89: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
90: to_serial_number WSH_DELIVERY_DETAILS.to_serial_number%TYPE,
91: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,
92: container_flag WSH_DELIVERY_DETAILS.container_flag%TYPE,
93: released_status WSH_DELIVERY_DETAILS.released_status%TYPE,
94: delivery_id wsh_delivery_assignments_v.delivery_id%TYPE,
95: parent_delivery_detail_id wsh_delivery_assignments_v.parent_delivery_detail_id%TYPE,

Line 92: container_flag WSH_DELIVERY_DETAILS.container_flag%TYPE,

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

Line 93: released_status WSH_DELIVERY_DETAILS.released_status%TYPE,

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

Line 97: oe_interfaced_flag WSH_DELIVERY_DETAILS.oe_interfaced_flag%TYPE,

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

Line 99: source_line_set_id WSH_DELIVERY_DETAILS.source_line_set_id%TYPE,

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

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

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

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

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

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

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

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

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

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

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

Line 106: gross_weight WSH_DELIVERY_DETAILS.gross_weight%TYPE,

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

Line 107: wv_frozen_flag WSH_DELIVERY_DETAILS.wv_frozen_flag%TYPE,

103: returned_quantity2 WSH_DELIVERY_DETAILS.returned_quantity2%TYPE,-- J-IB-NPARIKH
104: line_direction WSH_DELIVERY_DETAILS.line_direction%TYPE,-- J-IB-NPARIKH
105: -- J: W/V Changes
106: gross_weight WSH_DELIVERY_DETAILS.gross_weight%TYPE,
107: wv_frozen_flag WSH_DELIVERY_DETAILS.wv_frozen_flag%TYPE,
108: parent_delivery_id WSH_DELIVERY_ASSIGNMENTS_V.parent_delivery_id%TYPE,
109: wda_type WSH_DELIVERY_ASSIGNMENTS_V.type%TYPE,
110: replenishment_status WSH_DELIVERY_DETAILS.replenishment_status%TYPE, --bug# 6689448 (replenishment project)
111: consignee_flag WSH_DELIVERY_DETAILS.consignee_flag%TYPE, --RTV changes

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

106: gross_weight WSH_DELIVERY_DETAILS.gross_weight%TYPE,
107: wv_frozen_flag WSH_DELIVERY_DETAILS.wv_frozen_flag%TYPE,
108: parent_delivery_id WSH_DELIVERY_ASSIGNMENTS_V.parent_delivery_id%TYPE,
109: wda_type WSH_DELIVERY_ASSIGNMENTS_V.type%TYPE,
110: replenishment_status WSH_DELIVERY_DETAILS.replenishment_status%TYPE, --bug# 6689448 (replenishment project)
111: consignee_flag WSH_DELIVERY_DETAILS.consignee_flag%TYPE, --RTV changes
112: source_header_id WSH_DELIVERY_DETAILS.source_header_id%TYPE, --RTV changes
113: source_code WSH_DELIVERY_DETAILS.source_code%TYPE --RTV changes
114: );

Line 111: consignee_flag WSH_DELIVERY_DETAILS.consignee_flag%TYPE, --RTV changes

107: wv_frozen_flag WSH_DELIVERY_DETAILS.wv_frozen_flag%TYPE,
108: parent_delivery_id WSH_DELIVERY_ASSIGNMENTS_V.parent_delivery_id%TYPE,
109: wda_type WSH_DELIVERY_ASSIGNMENTS_V.type%TYPE,
110: replenishment_status WSH_DELIVERY_DETAILS.replenishment_status%TYPE, --bug# 6689448 (replenishment project)
111: consignee_flag WSH_DELIVERY_DETAILS.consignee_flag%TYPE, --RTV changes
112: source_header_id WSH_DELIVERY_DETAILS.source_header_id%TYPE, --RTV changes
113: source_code WSH_DELIVERY_DETAILS.source_code%TYPE --RTV changes
114: );
115:

Line 112: source_header_id WSH_DELIVERY_DETAILS.source_header_id%TYPE, --RTV changes

108: parent_delivery_id WSH_DELIVERY_ASSIGNMENTS_V.parent_delivery_id%TYPE,
109: wda_type WSH_DELIVERY_ASSIGNMENTS_V.type%TYPE,
110: replenishment_status WSH_DELIVERY_DETAILS.replenishment_status%TYPE, --bug# 6689448 (replenishment project)
111: consignee_flag WSH_DELIVERY_DETAILS.consignee_flag%TYPE, --RTV changes
112: source_header_id WSH_DELIVERY_DETAILS.source_header_id%TYPE, --RTV changes
113: source_code WSH_DELIVERY_DETAILS.source_code%TYPE --RTV changes
114: );
115:
116: -- anxsharm

Line 113: source_code WSH_DELIVERY_DETAILS.source_code%TYPE --RTV changes

109: wda_type WSH_DELIVERY_ASSIGNMENTS_V.type%TYPE,
110: replenishment_status WSH_DELIVERY_DETAILS.replenishment_status%TYPE, --bug# 6689448 (replenishment project)
111: consignee_flag WSH_DELIVERY_DETAILS.consignee_flag%TYPE, --RTV changes
112: source_header_id WSH_DELIVERY_DETAILS.source_header_id%TYPE, --RTV changes
113: source_code WSH_DELIVERY_DETAILS.source_code%TYPE --RTV changes
114: );
115:
116: -- anxsharm
117: -- for Split Serial Number

Line 119: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,

115:
116: -- anxsharm
117: -- for Split Serial Number
118: TYPE SerialRecType IS RECORD (
119: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
120: to_serial_number WSH_DELIVERY_DETAILS.to_serial_number%TYPE,
121: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,
122: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE);
123:

Line 120: to_serial_number WSH_DELIVERY_DETAILS.to_serial_number%TYPE,

116: -- anxsharm
117: -- for Split Serial Number
118: TYPE SerialRecType IS RECORD (
119: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
120: to_serial_number WSH_DELIVERY_DETAILS.to_serial_number%TYPE,
121: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,
122: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE);
123:
124: TYPE Serial_tab is TABLE of SerialRecType INDEX BY BINARY_INTEGER;

Line 121: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,

117: -- for Split Serial Number
118: TYPE SerialRecType IS RECORD (
119: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
120: to_serial_number WSH_DELIVERY_DETAILS.to_serial_number%TYPE,
121: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,
122: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE);
123:
124: TYPE Serial_tab is TABLE of SerialRecType INDEX BY BINARY_INTEGER;
125: --

Line 122: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE);

118: TYPE SerialRecType IS RECORD (
119: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
120: to_serial_number WSH_DELIVERY_DETAILS.to_serial_number%TYPE,
121: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,
122: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE);
123:
124: TYPE Serial_tab is TABLE of SerialRecType INDEX BY BINARY_INTEGER;
125: --
126: -- PACKAGE VARIABLES

Line 198: wsh_delivery_details wdd

194: wda.type wda_type,
195: wdd.client_id, -- LSP PROJECT
196: wdd.consignee_flag --RTV changes
197: FROM wsh_delivery_assignments_v wda,
198: wsh_delivery_details wdd
199: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
200: AND wda.delivery_detail_id = c_detail_id;
201:
202: -- Consolidation of Back Order Delivery Details Enhancement

Line 525: p_Cons_Source_Line_Rec_Tab IN WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab,

521: -- into one delivery detail id for the given source line id
522: --
523: --
524: PROCEDURE Consolidate_Source_Line(
525: p_Cons_Source_Line_Rec_Tab IN WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab,
526: x_consolidate_ids OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
527: x_return_status OUT NOCOPY VARCHAR2 );
528:
529:

Line 551: p_delivery_details_tab IN WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab,

547: -- delivery detail for each source line id.
548: --
549: -- HW OPM BUG#:3121616 Added x_remain_bo_qty2s
550: PROCEDURE Consolidate_Delivery_Details(
551: p_delivery_details_tab IN WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab,
552: p_bo_mode IN VARCHAR2,
553: x_cons_delivery_details_tab OUT NOCOPY WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab,
554: x_remain_bo_qtys OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
555: x_remain_bo_qty2s OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,

Line 553: x_cons_delivery_details_tab OUT NOCOPY WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab,

549: -- HW OPM BUG#:3121616 Added x_remain_bo_qty2s
550: PROCEDURE Consolidate_Delivery_Details(
551: p_delivery_details_tab IN WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab,
552: p_bo_mode IN VARCHAR2,
553: x_cons_delivery_details_tab OUT NOCOPY WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab,
554: x_remain_bo_qtys OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
555: x_remain_bo_qty2s OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
556: x_return_status OUT NOCOPY VARCHAR2
557: );

Line 568: END WSH_DELIVERY_DETAILS_ACTIONS;

564: PROCEDURE Delete_Consol_Record(
565: p_detail_id_tab IN wsh_util_core.id_tab_type,
566: x_return_status OUT NOCOPY VARCHAR2);
567:
568: END WSH_DELIVERY_DETAILS_ACTIONS;
569: