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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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
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
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
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,
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,
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,
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,
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,
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,
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),
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,
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
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: );