8: dd_interface_id NUMBER,
9: delivery_detail_id NUMBER,
10: tp_delivery_detail_id NUMBER,
11: mapped_quantity NUMBER,
12: mapped_quantity_uom WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY_UOM%TYPE,
13: map_split_flag VARCHAR2(1),
14: released_status WSH_DELIVERY_DETAILS.RELEASED_STATUS%TYPE,
15: move_order_line_id NUMBER,
16: line_direction WSH_DELIVERY_DETAILS.LINE_DIRECTION%TYPE,
10: tp_delivery_detail_id NUMBER,
11: mapped_quantity NUMBER,
12: mapped_quantity_uom WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY_UOM%TYPE,
13: map_split_flag VARCHAR2(1),
14: released_status WSH_DELIVERY_DETAILS.RELEASED_STATUS%TYPE,
15: move_order_line_id NUMBER,
16: line_direction WSH_DELIVERY_DETAILS.LINE_DIRECTION%TYPE,
17: source_code WSH_DELIVERY_DETAILS.SOURCE_CODE%TYPE,
18: source_header_id NUMBER,
12: mapped_quantity_uom WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY_UOM%TYPE,
13: map_split_flag VARCHAR2(1),
14: released_status WSH_DELIVERY_DETAILS.RELEASED_STATUS%TYPE,
15: move_order_line_id NUMBER,
16: line_direction WSH_DELIVERY_DETAILS.LINE_DIRECTION%TYPE,
17: source_code WSH_DELIVERY_DETAILS.SOURCE_CODE%TYPE,
18: source_header_id NUMBER,
19: source_line_set_id NUMBER,
20: source_line_id NUMBER,
13: map_split_flag VARCHAR2(1),
14: released_status WSH_DELIVERY_DETAILS.RELEASED_STATUS%TYPE,
15: move_order_line_id NUMBER,
16: line_direction WSH_DELIVERY_DETAILS.LINE_DIRECTION%TYPE,
17: source_code WSH_DELIVERY_DETAILS.SOURCE_CODE%TYPE,
18: source_header_id NUMBER,
19: source_line_set_id NUMBER,
20: source_line_id NUMBER,
21: po_shipment_line_id NUMBER, -- scope for mapping inbound/drop details
21: po_shipment_line_id NUMBER, -- scope for mapping inbound/drop details
22: ship_set_id NUMBER,
23: top_model_line_id NUMBER,
24: ato_line_id NUMBER,
25: ship_model_complete_flag WSH_DELIVERY_DETAILS.SHIP_MODEL_COMPLETE_FLAG%TYPE,
26: ship_from_location_id NUMBER,
27: ship_to_location_id NUMBER,
28: organization_id NUMBER,
29: customer_id NUMBER,
26: ship_from_location_id NUMBER,
27: ship_to_location_id NUMBER,
28: organization_id NUMBER,
29: customer_id NUMBER,
30: fob_code WSH_DELIVERY_DETAILS.FOB_CODE%TYPE,
31: freight_terms_code WSH_DELIVERY_DETAILS.FREIGHT_TERMS_CODE%TYPE,
32: intmed_ship_to_location_id NUMBER,
33: ship_method_code WSH_DELIVERY_DETAILS.SHIP_METHOD_CODE%TYPE,
34: mode_of_transport WSH_DELIVERY_DETAILS.MODE_OF_TRANSPORT%TYPE,
27: ship_to_location_id NUMBER,
28: organization_id NUMBER,
29: customer_id NUMBER,
30: fob_code WSH_DELIVERY_DETAILS.FOB_CODE%TYPE,
31: freight_terms_code WSH_DELIVERY_DETAILS.FREIGHT_TERMS_CODE%TYPE,
32: intmed_ship_to_location_id NUMBER,
33: ship_method_code WSH_DELIVERY_DETAILS.SHIP_METHOD_CODE%TYPE,
34: mode_of_transport WSH_DELIVERY_DETAILS.MODE_OF_TRANSPORT%TYPE,
35: service_level WSH_DELIVERY_DETAILS.SERVICE_LEVEL%TYPE,
29: customer_id NUMBER,
30: fob_code WSH_DELIVERY_DETAILS.FOB_CODE%TYPE,
31: freight_terms_code WSH_DELIVERY_DETAILS.FREIGHT_TERMS_CODE%TYPE,
32: intmed_ship_to_location_id NUMBER,
33: ship_method_code WSH_DELIVERY_DETAILS.SHIP_METHOD_CODE%TYPE,
34: mode_of_transport WSH_DELIVERY_DETAILS.MODE_OF_TRANSPORT%TYPE,
35: service_level WSH_DELIVERY_DETAILS.SERVICE_LEVEL%TYPE,
36: carrier_id NUMBER,
37: shipping_control WSH_DELIVERY_DETAILS.SHIPPING_CONTROL%TYPE,
30: fob_code WSH_DELIVERY_DETAILS.FOB_CODE%TYPE,
31: freight_terms_code WSH_DELIVERY_DETAILS.FREIGHT_TERMS_CODE%TYPE,
32: intmed_ship_to_location_id NUMBER,
33: ship_method_code WSH_DELIVERY_DETAILS.SHIP_METHOD_CODE%TYPE,
34: mode_of_transport WSH_DELIVERY_DETAILS.MODE_OF_TRANSPORT%TYPE,
35: service_level WSH_DELIVERY_DETAILS.SERVICE_LEVEL%TYPE,
36: carrier_id NUMBER,
37: shipping_control WSH_DELIVERY_DETAILS.SHIPPING_CONTROL%TYPE,
38: vendor_id WSH_DELIVERY_DETAILS.VENDOR_ID%TYPE,
31: freight_terms_code WSH_DELIVERY_DETAILS.FREIGHT_TERMS_CODE%TYPE,
32: intmed_ship_to_location_id NUMBER,
33: ship_method_code WSH_DELIVERY_DETAILS.SHIP_METHOD_CODE%TYPE,
34: mode_of_transport WSH_DELIVERY_DETAILS.MODE_OF_TRANSPORT%TYPE,
35: service_level WSH_DELIVERY_DETAILS.SERVICE_LEVEL%TYPE,
36: carrier_id NUMBER,
37: shipping_control WSH_DELIVERY_DETAILS.SHIPPING_CONTROL%TYPE,
38: vendor_id WSH_DELIVERY_DETAILS.VENDOR_ID%TYPE,
39: party_id WSH_DELIVERY_DETAILS.PARTY_ID%TYPE,
33: ship_method_code WSH_DELIVERY_DETAILS.SHIP_METHOD_CODE%TYPE,
34: mode_of_transport WSH_DELIVERY_DETAILS.MODE_OF_TRANSPORT%TYPE,
35: service_level WSH_DELIVERY_DETAILS.SERVICE_LEVEL%TYPE,
36: carrier_id NUMBER,
37: shipping_control WSH_DELIVERY_DETAILS.SHIPPING_CONTROL%TYPE,
38: vendor_id WSH_DELIVERY_DETAILS.VENDOR_ID%TYPE,
39: party_id WSH_DELIVERY_DETAILS.PARTY_ID%TYPE,
40: topmost_cont_id NUMBER,
41: current_delivery_id NUMBER,
34: mode_of_transport WSH_DELIVERY_DETAILS.MODE_OF_TRANSPORT%TYPE,
35: service_level WSH_DELIVERY_DETAILS.SERVICE_LEVEL%TYPE,
36: carrier_id NUMBER,
37: shipping_control WSH_DELIVERY_DETAILS.SHIPPING_CONTROL%TYPE,
38: vendor_id WSH_DELIVERY_DETAILS.VENDOR_ID%TYPE,
39: party_id WSH_DELIVERY_DETAILS.PARTY_ID%TYPE,
40: topmost_cont_id NUMBER,
41: current_delivery_id NUMBER,
42: target_delivery_index NUMBER,
35: service_level WSH_DELIVERY_DETAILS.SERVICE_LEVEL%TYPE,
36: carrier_id NUMBER,
37: shipping_control WSH_DELIVERY_DETAILS.SHIPPING_CONTROL%TYPE,
38: vendor_id WSH_DELIVERY_DETAILS.VENDOR_ID%TYPE,
39: party_id WSH_DELIVERY_DETAILS.PARTY_ID%TYPE,
40: topmost_cont_id NUMBER,
41: current_delivery_id NUMBER,
42: target_delivery_index NUMBER,
43: wv_frozen_flag WSH_DELIVERY_DETAILS.WV_FROZEN_FLAG%TYPE
39: party_id WSH_DELIVERY_DETAILS.PARTY_ID%TYPE,
40: topmost_cont_id NUMBER,
41: current_delivery_id NUMBER,
42: target_delivery_index NUMBER,
43: wv_frozen_flag WSH_DELIVERY_DETAILS.WV_FROZEN_FLAG%TYPE
44: );
45: TYPE plan_detail_tab_type IS TABLE OF plan_detail_rec_type INDEX BY BINARY_INTEGER;
46:
47:
73: shipping_control WSH_NEW_DELIVERIES.SHIPPING_CONTROL%TYPE,
74: vendor_id WSH_NEW_DELIVERIES.VENDOR_ID%TYPE,
75: organization_id NUMBER,
76: customer_id NUMBER,
77: fob_code WSH_DELIVERY_DETAILS.FOB_CODE%TYPE,
78: intmed_ship_to_location_id NUMBER,
79: carrier_id NUMBER,
80: shipment_direction WSH_NEW_DELIVERIES.SHIPMENT_DIRECTION%TYPE,
81: additional_shipment_info WSH_NEW_DELIVERIES.ADDITIONAL_SHIPMENT_INFO%TYPE,
185: TYPE used_detail_rec_type IS RECORD (
186: delivery_detail_id NUMBER,
187: dd_interface_id NUMBER,
188: available_quantity NUMBER,
189: available_quantity_uom WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY_UOM%TYPE,
190: current_delivery_id NUMBER,
191: topmost_cont_id NUMBER,
192: target_delivery_index NUMBER,
193: track_cont_content_found BOOLEAN,
195: move_order_line_id NUMBER,
196: split_count NUMBER,
197: need_unassignment BOOLEAN,
198: organization_id NUMBER,
199: line_direction WSH_DELIVERY_DETAILS.LINE_DIRECTION%TYPE
200: );
201: TYPE used_details_tab_type IS TABLE OF used_detail_rec_type INDEX BY BINARY_INTEGER;
202:
203:
211: lines_staged BOOLEAN,
212: cont_content_base_index NUMBER,
213: lpn_id NUMBER,
214: released_status VARCHAR2(1),
215: source_code WSH_DELIVERY_DETAILS.SOURCE_CODE%TYPE,
216: organization_id NUMBER
217: );
218: TYPE track_cont_tab_type IS TABLE OF track_cont_rec_type INDEX BY BINARY_INTEGER;
219:
233: organization_id NUMBER,
234: container_flag VARCHAR2(1),
235: lines_staged BOOLEAN,
236: wms_org_flag VARCHAR2(1),
237: source_code WSH_DELIVERY_DETAILS.SOURCE_CODE%TYPE,
238: released_status WSH_DELIVERY_DETAILS.RELEASED_STATUS%TYPE,
239: lpn_id NUMBER,
240: plan_dd_index NUMBER, -- index to x_plan_details for plan line
241: plan_del_index NUMBER, -- index to x_plan_deliveries for plan delivery
234: container_flag VARCHAR2(1),
235: lines_staged BOOLEAN,
236: wms_org_flag VARCHAR2(1),
237: source_code WSH_DELIVERY_DETAILS.SOURCE_CODE%TYPE,
238: released_status WSH_DELIVERY_DETAILS.RELEASED_STATUS%TYPE,
239: lpn_id NUMBER,
240: plan_dd_index NUMBER, -- index to x_plan_details for plan line
241: plan_del_index NUMBER, -- index to x_plan_deliveries for plan delivery
242: wv_frozen_flag WSH_NEW_DELIVERIES.WV_FROZEN_FLAG%TYPE,