DBA Data[Home] [Help]

APPS.WSH_DELIVERY_AUTOCREATE dependencies on WSH_DELIVERY_DETAILS

Line 190: ship_to_location_id wsh_delivery_details.ship_to_location_id%type,

186: entity_id number,
187: entity_type varchar2(30),
188: status_code varchar2(30),
189: planned_flag varchar2(1),
190: ship_to_location_id wsh_delivery_details.ship_to_location_id%type,
191: ship_from_location_id wsh_delivery_details.ship_from_location_id%type,
192: customer_id wsh_delivery_details.customer_id%type,
193: intmed_ship_to_location_id wsh_delivery_details.intmed_ship_to_location_id%type,
194: fob_code wsh_delivery_details.fob_code%type,

Line 191: ship_from_location_id wsh_delivery_details.ship_from_location_id%type,

187: entity_type varchar2(30),
188: status_code varchar2(30),
189: planned_flag varchar2(1),
190: ship_to_location_id wsh_delivery_details.ship_to_location_id%type,
191: ship_from_location_id wsh_delivery_details.ship_from_location_id%type,
192: customer_id wsh_delivery_details.customer_id%type,
193: intmed_ship_to_location_id wsh_delivery_details.intmed_ship_to_location_id%type,
194: fob_code wsh_delivery_details.fob_code%type,
195: freight_terms_code wsh_delivery_details.freight_terms_code%type,

Line 192: customer_id wsh_delivery_details.customer_id%type,

188: status_code varchar2(30),
189: planned_flag varchar2(1),
190: ship_to_location_id wsh_delivery_details.ship_to_location_id%type,
191: ship_from_location_id wsh_delivery_details.ship_from_location_id%type,
192: customer_id wsh_delivery_details.customer_id%type,
193: intmed_ship_to_location_id wsh_delivery_details.intmed_ship_to_location_id%type,
194: fob_code wsh_delivery_details.fob_code%type,
195: freight_terms_code wsh_delivery_details.freight_terms_code%type,
196: ship_method_code wsh_delivery_details.ship_method_code%type,

Line 193: intmed_ship_to_location_id wsh_delivery_details.intmed_ship_to_location_id%type,

189: planned_flag varchar2(1),
190: ship_to_location_id wsh_delivery_details.ship_to_location_id%type,
191: ship_from_location_id wsh_delivery_details.ship_from_location_id%type,
192: customer_id wsh_delivery_details.customer_id%type,
193: intmed_ship_to_location_id wsh_delivery_details.intmed_ship_to_location_id%type,
194: fob_code wsh_delivery_details.fob_code%type,
195: freight_terms_code wsh_delivery_details.freight_terms_code%type,
196: ship_method_code wsh_delivery_details.ship_method_code%type,
197: carrier_id wsh_delivery_details.carrier_id%type,

Line 194: fob_code wsh_delivery_details.fob_code%type,

190: ship_to_location_id wsh_delivery_details.ship_to_location_id%type,
191: ship_from_location_id wsh_delivery_details.ship_from_location_id%type,
192: customer_id wsh_delivery_details.customer_id%type,
193: intmed_ship_to_location_id wsh_delivery_details.intmed_ship_to_location_id%type,
194: fob_code wsh_delivery_details.fob_code%type,
195: freight_terms_code wsh_delivery_details.freight_terms_code%type,
196: ship_method_code wsh_delivery_details.ship_method_code%type,
197: carrier_id wsh_delivery_details.carrier_id%type,
198: source_header_id wsh_delivery_details.source_header_id%type,

Line 195: freight_terms_code wsh_delivery_details.freight_terms_code%type,

191: ship_from_location_id wsh_delivery_details.ship_from_location_id%type,
192: customer_id wsh_delivery_details.customer_id%type,
193: intmed_ship_to_location_id wsh_delivery_details.intmed_ship_to_location_id%type,
194: fob_code wsh_delivery_details.fob_code%type,
195: freight_terms_code wsh_delivery_details.freight_terms_code%type,
196: ship_method_code wsh_delivery_details.ship_method_code%type,
197: carrier_id wsh_delivery_details.carrier_id%type,
198: source_header_id wsh_delivery_details.source_header_id%type,
199: deliver_to_location_id wsh_delivery_details.deliver_to_location_id%type,

Line 196: ship_method_code wsh_delivery_details.ship_method_code%type,

192: customer_id wsh_delivery_details.customer_id%type,
193: intmed_ship_to_location_id wsh_delivery_details.intmed_ship_to_location_id%type,
194: fob_code wsh_delivery_details.fob_code%type,
195: freight_terms_code wsh_delivery_details.freight_terms_code%type,
196: ship_method_code wsh_delivery_details.ship_method_code%type,
197: carrier_id wsh_delivery_details.carrier_id%type,
198: source_header_id wsh_delivery_details.source_header_id%type,
199: deliver_to_location_id wsh_delivery_details.deliver_to_location_id%type,
200: organization_id wsh_delivery_details.organization_id%type,

Line 197: carrier_id wsh_delivery_details.carrier_id%type,

193: intmed_ship_to_location_id wsh_delivery_details.intmed_ship_to_location_id%type,
194: fob_code wsh_delivery_details.fob_code%type,
195: freight_terms_code wsh_delivery_details.freight_terms_code%type,
196: ship_method_code wsh_delivery_details.ship_method_code%type,
197: carrier_id wsh_delivery_details.carrier_id%type,
198: source_header_id wsh_delivery_details.source_header_id%type,
199: deliver_to_location_id wsh_delivery_details.deliver_to_location_id%type,
200: organization_id wsh_delivery_details.organization_id%type,
201: date_scheduled wsh_delivery_details.date_scheduled%type,

Line 198: source_header_id wsh_delivery_details.source_header_id%type,

194: fob_code wsh_delivery_details.fob_code%type,
195: freight_terms_code wsh_delivery_details.freight_terms_code%type,
196: ship_method_code wsh_delivery_details.ship_method_code%type,
197: carrier_id wsh_delivery_details.carrier_id%type,
198: source_header_id wsh_delivery_details.source_header_id%type,
199: deliver_to_location_id wsh_delivery_details.deliver_to_location_id%type,
200: organization_id wsh_delivery_details.organization_id%type,
201: date_scheduled wsh_delivery_details.date_scheduled%type,
202: date_requested wsh_delivery_details.date_requested%type,

Line 199: deliver_to_location_id wsh_delivery_details.deliver_to_location_id%type,

195: freight_terms_code wsh_delivery_details.freight_terms_code%type,
196: ship_method_code wsh_delivery_details.ship_method_code%type,
197: carrier_id wsh_delivery_details.carrier_id%type,
198: source_header_id wsh_delivery_details.source_header_id%type,
199: deliver_to_location_id wsh_delivery_details.deliver_to_location_id%type,
200: organization_id wsh_delivery_details.organization_id%type,
201: date_scheduled wsh_delivery_details.date_scheduled%type,
202: date_requested wsh_delivery_details.date_requested%type,
203: delivery_id wsh_new_deliveries.delivery_id%type,

Line 200: organization_id wsh_delivery_details.organization_id%type,

196: ship_method_code wsh_delivery_details.ship_method_code%type,
197: carrier_id wsh_delivery_details.carrier_id%type,
198: source_header_id wsh_delivery_details.source_header_id%type,
199: deliver_to_location_id wsh_delivery_details.deliver_to_location_id%type,
200: organization_id wsh_delivery_details.organization_id%type,
201: date_scheduled wsh_delivery_details.date_scheduled%type,
202: date_requested wsh_delivery_details.date_requested%type,
203: delivery_id wsh_new_deliveries.delivery_id%type,
204: ignore_for_planning wsh_delivery_details.ignore_for_planning%type DEFAULT 'N',--J TP Release

Line 201: date_scheduled wsh_delivery_details.date_scheduled%type,

197: carrier_id wsh_delivery_details.carrier_id%type,
198: source_header_id wsh_delivery_details.source_header_id%type,
199: deliver_to_location_id wsh_delivery_details.deliver_to_location_id%type,
200: organization_id wsh_delivery_details.organization_id%type,
201: date_scheduled wsh_delivery_details.date_scheduled%type,
202: date_requested wsh_delivery_details.date_requested%type,
203: delivery_id wsh_new_deliveries.delivery_id%type,
204: ignore_for_planning wsh_delivery_details.ignore_for_planning%type DEFAULT 'N',--J TP Release
205: line_direction wsh_delivery_details.line_direction%TYPE, -- J-IB-NPARIKH

Line 202: date_requested wsh_delivery_details.date_requested%type,

198: source_header_id wsh_delivery_details.source_header_id%type,
199: deliver_to_location_id wsh_delivery_details.deliver_to_location_id%type,
200: organization_id wsh_delivery_details.organization_id%type,
201: date_scheduled wsh_delivery_details.date_scheduled%type,
202: date_requested wsh_delivery_details.date_requested%type,
203: delivery_id wsh_new_deliveries.delivery_id%type,
204: ignore_for_planning wsh_delivery_details.ignore_for_planning%type DEFAULT 'N',--J TP Release
205: line_direction wsh_delivery_details.line_direction%TYPE, -- J-IB-NPARIKH
206: shipping_control wsh_delivery_details.shipping_control%TYPE, -- J-IB-NPARIKH

Line 204: ignore_for_planning wsh_delivery_details.ignore_for_planning%type DEFAULT 'N',--J TP Release

200: organization_id wsh_delivery_details.organization_id%type,
201: date_scheduled wsh_delivery_details.date_scheduled%type,
202: date_requested wsh_delivery_details.date_requested%type,
203: delivery_id wsh_new_deliveries.delivery_id%type,
204: ignore_for_planning wsh_delivery_details.ignore_for_planning%type DEFAULT 'N',--J TP Release
205: line_direction wsh_delivery_details.line_direction%TYPE, -- J-IB-NPARIKH
206: shipping_control wsh_delivery_details.shipping_control%TYPE, -- J-IB-NPARIKH
207: vendor_id wsh_delivery_details.vendor_id%TYPE, -- J-IB-NPARIKH
208: party_id wsh_delivery_details.party_id%TYPE, -- J-IB-NPARIKH

Line 205: line_direction wsh_delivery_details.line_direction%TYPE, -- J-IB-NPARIKH

201: date_scheduled wsh_delivery_details.date_scheduled%type,
202: date_requested wsh_delivery_details.date_requested%type,
203: delivery_id wsh_new_deliveries.delivery_id%type,
204: ignore_for_planning wsh_delivery_details.ignore_for_planning%type DEFAULT 'N',--J TP Release
205: line_direction wsh_delivery_details.line_direction%TYPE, -- J-IB-NPARIKH
206: shipping_control wsh_delivery_details.shipping_control%TYPE, -- J-IB-NPARIKH
207: vendor_id wsh_delivery_details.vendor_id%TYPE, -- J-IB-NPARIKH
208: party_id wsh_delivery_details.party_id%TYPE, -- J-IB-NPARIKH
209: mode_of_transport wsh_delivery_details.mode_of_transport%TYPE,

Line 206: shipping_control wsh_delivery_details.shipping_control%TYPE, -- J-IB-NPARIKH

202: date_requested wsh_delivery_details.date_requested%type,
203: delivery_id wsh_new_deliveries.delivery_id%type,
204: ignore_for_planning wsh_delivery_details.ignore_for_planning%type DEFAULT 'N',--J TP Release
205: line_direction wsh_delivery_details.line_direction%TYPE, -- J-IB-NPARIKH
206: shipping_control wsh_delivery_details.shipping_control%TYPE, -- J-IB-NPARIKH
207: vendor_id wsh_delivery_details.vendor_id%TYPE, -- J-IB-NPARIKH
208: party_id wsh_delivery_details.party_id%TYPE, -- J-IB-NPARIKH
209: mode_of_transport wsh_delivery_details.mode_of_transport%TYPE,
210: service_level wsh_delivery_details.service_level%TYPE,

Line 207: vendor_id wsh_delivery_details.vendor_id%TYPE, -- J-IB-NPARIKH

203: delivery_id wsh_new_deliveries.delivery_id%type,
204: ignore_for_planning wsh_delivery_details.ignore_for_planning%type DEFAULT 'N',--J TP Release
205: line_direction wsh_delivery_details.line_direction%TYPE, -- J-IB-NPARIKH
206: shipping_control wsh_delivery_details.shipping_control%TYPE, -- J-IB-NPARIKH
207: vendor_id wsh_delivery_details.vendor_id%TYPE, -- J-IB-NPARIKH
208: party_id wsh_delivery_details.party_id%TYPE, -- J-IB-NPARIKH
209: mode_of_transport wsh_delivery_details.mode_of_transport%TYPE,
210: service_level wsh_delivery_details.service_level%TYPE,
211: lpn_id wsh_delivery_details.lpn_id%TYPE,

Line 208: party_id wsh_delivery_details.party_id%TYPE, -- J-IB-NPARIKH

204: ignore_for_planning wsh_delivery_details.ignore_for_planning%type DEFAULT 'N',--J TP Release
205: line_direction wsh_delivery_details.line_direction%TYPE, -- J-IB-NPARIKH
206: shipping_control wsh_delivery_details.shipping_control%TYPE, -- J-IB-NPARIKH
207: vendor_id wsh_delivery_details.vendor_id%TYPE, -- J-IB-NPARIKH
208: party_id wsh_delivery_details.party_id%TYPE, -- J-IB-NPARIKH
209: mode_of_transport wsh_delivery_details.mode_of_transport%TYPE,
210: service_level wsh_delivery_details.service_level%TYPE,
211: lpn_id wsh_delivery_details.lpn_id%TYPE,
212: inventory_item_id wsh_delivery_details.inventory_item_id%TYPE,

Line 209: mode_of_transport wsh_delivery_details.mode_of_transport%TYPE,

205: line_direction wsh_delivery_details.line_direction%TYPE, -- J-IB-NPARIKH
206: shipping_control wsh_delivery_details.shipping_control%TYPE, -- J-IB-NPARIKH
207: vendor_id wsh_delivery_details.vendor_id%TYPE, -- J-IB-NPARIKH
208: party_id wsh_delivery_details.party_id%TYPE, -- J-IB-NPARIKH
209: mode_of_transport wsh_delivery_details.mode_of_transport%TYPE,
210: service_level wsh_delivery_details.service_level%TYPE,
211: lpn_id wsh_delivery_details.lpn_id%TYPE,
212: inventory_item_id wsh_delivery_details.inventory_item_id%TYPE,
213: source_code wsh_delivery_details.source_code%TYPE,

Line 210: service_level wsh_delivery_details.service_level%TYPE,

206: shipping_control wsh_delivery_details.shipping_control%TYPE, -- J-IB-NPARIKH
207: vendor_id wsh_delivery_details.vendor_id%TYPE, -- J-IB-NPARIKH
208: party_id wsh_delivery_details.party_id%TYPE, -- J-IB-NPARIKH
209: mode_of_transport wsh_delivery_details.mode_of_transport%TYPE,
210: service_level wsh_delivery_details.service_level%TYPE,
211: lpn_id wsh_delivery_details.lpn_id%TYPE,
212: inventory_item_id wsh_delivery_details.inventory_item_id%TYPE,
213: source_code wsh_delivery_details.source_code%TYPE,
214: container_flag wsh_delivery_details.container_flag%TYPE,

Line 211: lpn_id wsh_delivery_details.lpn_id%TYPE,

207: vendor_id wsh_delivery_details.vendor_id%TYPE, -- J-IB-NPARIKH
208: party_id wsh_delivery_details.party_id%TYPE, -- J-IB-NPARIKH
209: mode_of_transport wsh_delivery_details.mode_of_transport%TYPE,
210: service_level wsh_delivery_details.service_level%TYPE,
211: lpn_id wsh_delivery_details.lpn_id%TYPE,
212: inventory_item_id wsh_delivery_details.inventory_item_id%TYPE,
213: source_code wsh_delivery_details.source_code%TYPE,
214: container_flag wsh_delivery_details.container_flag%TYPE,
215: l1_hash_string varchar2(1000),

Line 212: inventory_item_id wsh_delivery_details.inventory_item_id%TYPE,

208: party_id wsh_delivery_details.party_id%TYPE, -- J-IB-NPARIKH
209: mode_of_transport wsh_delivery_details.mode_of_transport%TYPE,
210: service_level wsh_delivery_details.service_level%TYPE,
211: lpn_id wsh_delivery_details.lpn_id%TYPE,
212: inventory_item_id wsh_delivery_details.inventory_item_id%TYPE,
213: source_code wsh_delivery_details.source_code%TYPE,
214: container_flag wsh_delivery_details.container_flag%TYPE,
215: l1_hash_string varchar2(1000),
216: l1_hash_value number,

Line 213: source_code wsh_delivery_details.source_code%TYPE,

209: mode_of_transport wsh_delivery_details.mode_of_transport%TYPE,
210: service_level wsh_delivery_details.service_level%TYPE,
211: lpn_id wsh_delivery_details.lpn_id%TYPE,
212: inventory_item_id wsh_delivery_details.inventory_item_id%TYPE,
213: source_code wsh_delivery_details.source_code%TYPE,
214: container_flag wsh_delivery_details.container_flag%TYPE,
215: l1_hash_string varchar2(1000),
216: l1_hash_value number,
217: is_xdocked_flag varchar2(1) DEFAULT 'N'--X-dock

Line 214: container_flag wsh_delivery_details.container_flag%TYPE,

210: service_level wsh_delivery_details.service_level%TYPE,
211: lpn_id wsh_delivery_details.lpn_id%TYPE,
212: inventory_item_id wsh_delivery_details.inventory_item_id%TYPE,
213: source_code wsh_delivery_details.source_code%TYPE,
214: container_flag wsh_delivery_details.container_flag%TYPE,
215: l1_hash_string varchar2(1000),
216: l1_hash_value number,
217: is_xdocked_flag varchar2(1) DEFAULT 'N'--X-dock
218: );