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_ASSIGNMENTS

Line 57: wsh_delivery_assignments wda

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');
61:

Line 94: delivery_id wsh_delivery_assignments_v.delivery_id%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,
98: -- anxsharm bug 2181132

Line 95: parent_delivery_detail_id wsh_delivery_assignments_v.parent_delivery_detail_id%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,
98: -- anxsharm bug 2181132
99: source_line_set_id WSH_DELIVERY_DETAILS.source_line_set_id%TYPE,

Line 108: parent_delivery_id WSH_DELIVERY_ASSIGNMENTS_V.parent_delivery_id%TYPE,

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
112: source_header_id WSH_DELIVERY_DETAILS.source_header_id%TYPE, --RTV changes

Line 109: wda_type WSH_DELIVERY_ASSIGNMENTS_V.type%TYPE,

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
112: source_header_id WSH_DELIVERY_DETAILS.source_header_id%TYPE, --RTV changes
113: source_code WSH_DELIVERY_DETAILS.source_code%TYPE --RTV changes

Line 133: --Based on assumption that we are using wsh_delivery_assignments_v,

129: Instead of Using 2 cursors just use One Cursor with a UNION
130: */
131: --
132: -- LPN CONV. rv
133: --Based on assumption that we are using wsh_delivery_assignments_v,
134: --delivery and its contents will belong to same organization.
135: --Similarly, container and its contents will belong to same organization.
136: --Hence, we are checking for WMS org or non-WMS org. at the parent level (i.e. delivery/container)
137: --rather than at line-level for performance reasons.

Line 140: -- i.e Query was changed to refer to base table wsh_delivery_assignments instead of

136: --Hence, we are checking for WMS org or non-WMS org. at the parent level (i.e. delivery/container)
137: --rather than at line-level for performance reasons.
138:
139: --If this assumptions were to be violated in anyway
140: -- i.e Query was changed to refer to base table wsh_delivery_assignments instead of
141: -- wsh_delivery_assignments_v
142: -- or
143: -- if existing query were to somehow return/fetch records where
144: -- delivery and its contents may belong to diff. org.

Line 141: -- wsh_delivery_assignments_v

137: --rather than at line-level for performance reasons.
138:
139: --If this assumptions were to be violated in anyway
140: -- i.e Query was changed to refer to base table wsh_delivery_assignments instead of
141: -- wsh_delivery_assignments_v
142: -- or
143: -- if existing query were to somehow return/fetch records where
144: -- delivery and its contents may belong to diff. org.
145: -- container and its contents may belong to diff. org.

Line 155: FROM wsh_delivery_assignments_v

151: CURSOR C_INSIDE_OUTSIDE_OF_CONTAINER (c_detail_id number) is
152: SELECT delivery_detail_id,
153: parent_delivery_detail_id,
154: delivery_id
155: FROM wsh_delivery_assignments_v
156: START WITH delivery_detail_id = c_detail_id
157: CONNECT BY prior delivery_detail_id = parent_delivery_detail_id
158: UNION
159: SELECT delivery_detail_id,

Line 162: FROM wsh_delivery_assignments_v

158: UNION
159: SELECT delivery_detail_id,
160: parent_delivery_detail_id,
161: delivery_id
162: FROM wsh_delivery_assignments_v
163: START WITH delivery_detail_id = c_detail_id
164: CONNECT BY prior parent_delivery_detail_id = delivery_detail_id;
165:
166: /** Variable Declaration for Fetching the Cursor */

Line 197: FROM wsh_delivery_assignments_v wda,

193: wdd.inventory_item_id,
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: