DBA Data[Home] [Help]

APPS.WSH_TP_RELEASE_INT dependencies on WSH_DELIVERY_DETAILS

Line 12: mapped_quantity_uom WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY_UOM%TYPE,

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,

Line 14: released_status WSH_DELIVERY_DETAILS.RELEASED_STATUS%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,

Line 16: line_direction WSH_DELIVERY_DETAILS.LINE_DIRECTION%TYPE,

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,

Line 17: source_code WSH_DELIVERY_DETAILS.SOURCE_CODE%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,
21: po_shipment_line_id NUMBER, -- scope for mapping inbound/drop details

Line 25: ship_model_complete_flag WSH_DELIVERY_DETAILS.SHIP_MODEL_COMPLETE_FLAG%TYPE,

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,

Line 30: fob_code WSH_DELIVERY_DETAILS.FOB_CODE%TYPE,

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,

Line 31: freight_terms_code WSH_DELIVERY_DETAILS.FREIGHT_TERMS_CODE%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,

Line 33: ship_method_code WSH_DELIVERY_DETAILS.SHIP_METHOD_CODE%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,

Line 34: mode_of_transport WSH_DELIVERY_DETAILS.MODE_OF_TRANSPORT%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,

Line 35: service_level WSH_DELIVERY_DETAILS.SERVICE_LEVEL%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,

Line 37: shipping_control WSH_DELIVERY_DETAILS.SHIPPING_CONTROL%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,

Line 38: vendor_id WSH_DELIVERY_DETAILS.VENDOR_ID%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,
42: target_delivery_index NUMBER,

Line 39: party_id WSH_DELIVERY_DETAILS.PARTY_ID%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,
43: wv_frozen_flag WSH_DELIVERY_DETAILS.WV_FROZEN_FLAG%TYPE

Line 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:

Line 77: fob_code WSH_DELIVERY_DETAILS.FOB_CODE%TYPE,

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,

Line 189: available_quantity_uom WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY_UOM%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,

Line 199: line_direction WSH_DELIVERY_DETAILS.LINE_DIRECTION%TYPE

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:

Line 215: source_code WSH_DELIVERY_DETAILS.SOURCE_CODE%TYPE,

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:

Line 237: source_code WSH_DELIVERY_DETAILS.SOURCE_CODE%TYPE,

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

Line 238: released_status WSH_DELIVERY_DETAILS.RELEASED_STATUS%TYPE,

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,