21:
22: PROCEDURE detail_to_delivery(
23: -- Standard parameters
24: p_api_version IN NUMBER,
25: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
26: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
28: x_return_status OUT NOCOPY VARCHAR2,
29: x_msg_count OUT NOCOPY NUMBER,
22: PROCEDURE detail_to_delivery(
23: -- Standard parameters
24: p_api_version IN NUMBER,
25: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
26: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
28: x_return_status OUT NOCOPY VARCHAR2,
29: x_msg_count OUT NOCOPY NUMBER,
30: x_msg_data OUT NOCOPY VARCHAR2,
23: -- Standard parameters
24: p_api_version IN NUMBER,
25: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
26: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
28: x_return_status OUT NOCOPY VARCHAR2,
29: x_msg_count OUT NOCOPY NUMBER,
30: x_msg_data OUT NOCOPY VARCHAR2,
31: -- program specific parameters
30: x_msg_data OUT NOCOPY VARCHAR2,
31: -- program specific parameters
32: p_TabOfDelDets IN WSH_UTIL_CORE.ID_TAB_TYPE,
33: p_action IN VARCHAR2,
34: p_delivery_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
35: p_delivery_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
36: p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type -- J-IB-NPARIKH
37: );
38:
31: -- program specific parameters
32: p_TabOfDelDets IN WSH_UTIL_CORE.ID_TAB_TYPE,
33: p_action IN VARCHAR2,
34: p_delivery_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
35: p_delivery_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
36: p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type -- J-IB-NPARIKH
37: );
38:
39: --This procedure is for backward compatibility only. Do not use this.
39: --This procedure is for backward compatibility only. Do not use this.
40: PROCEDURE detail_to_delivery(
41: -- Standard parameters
42: p_api_version IN NUMBER,
43: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
44: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
45: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
46: x_return_status OUT NOCOPY VARCHAR2,
47: x_msg_count OUT NOCOPY NUMBER,
40: PROCEDURE detail_to_delivery(
41: -- Standard parameters
42: p_api_version IN NUMBER,
43: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
44: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
45: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
46: x_return_status OUT NOCOPY VARCHAR2,
47: x_msg_count OUT NOCOPY NUMBER,
48: x_msg_data OUT NOCOPY VARCHAR2,
41: -- Standard parameters
42: p_api_version IN NUMBER,
43: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
44: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
45: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
46: x_return_status OUT NOCOPY VARCHAR2,
47: x_msg_count OUT NOCOPY NUMBER,
48: x_msg_data OUT NOCOPY VARCHAR2,
49: -- program specific parameters
48: x_msg_data OUT NOCOPY VARCHAR2,
49: -- program specific parameters
50: p_TabOfDelDets IN WSH_UTIL_CORE.ID_TAB_TYPE,
51: p_action IN VARCHAR2,
52: p_delivery_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
53: p_delivery_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
54: );
55:
56:
49: -- program specific parameters
50: p_TabOfDelDets IN WSH_UTIL_CORE.ID_TAB_TYPE,
51: p_action IN VARCHAR2,
52: p_delivery_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
53: p_delivery_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
54: );
55:
56:
57: -- ----------------------------------------------------------------------
65:
66: PROCEDURE split_line(
67: -- Standard parameters
68: p_api_version IN NUMBER,
69: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
70: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
71: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
72: x_return_status OUT NOCOPY VARCHAR2,
73: x_msg_count OUT NOCOPY NUMBER,
66: PROCEDURE split_line(
67: -- Standard parameters
68: p_api_version IN NUMBER,
69: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
70: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
71: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
72: x_return_status OUT NOCOPY VARCHAR2,
73: x_msg_count OUT NOCOPY NUMBER,
74: x_msg_data OUT NOCOPY VARCHAR2,
67: -- Standard parameters
68: p_api_version IN NUMBER,
69: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
70: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
71: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
72: x_return_status OUT NOCOPY VARCHAR2,
73: x_msg_count OUT NOCOPY NUMBER,
74: x_msg_data OUT NOCOPY VARCHAR2,
75:
85:
86: --bug 1747202: default these attributes so they won't be updated.
87: /* Not needed any more since we use WSH_INTERFACE.ChangedAttributeTabType
88: TYPE ChangedAttributeRecType IS RECORD (
89: arrival_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,
90: ato_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
91: attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
92: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
93: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
86: --bug 1747202: default these attributes so they won't be updated.
87: /* Not needed any more since we use WSH_INTERFACE.ChangedAttributeTabType
88: TYPE ChangedAttributeRecType IS RECORD (
89: arrival_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,
90: ato_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
91: attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
92: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
93: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
94: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
87: /* Not needed any more since we use WSH_INTERFACE.ChangedAttributeTabType
88: TYPE ChangedAttributeRecType IS RECORD (
89: arrival_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,
90: ato_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
91: attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
92: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
93: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
94: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
95: attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
88: TYPE ChangedAttributeRecType IS RECORD (
89: arrival_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,
90: ato_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
91: attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
92: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
93: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
94: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
95: attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
96: attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
89: arrival_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,
90: ato_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
91: attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
92: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
93: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
94: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
95: attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
96: attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
97: attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
90: ato_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
91: attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
92: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
93: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
94: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
95: attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
96: attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
97: attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
98: attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
91: attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
92: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
93: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
94: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
95: attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
96: attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
97: attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
98: attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
99: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
92: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
93: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
94: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
95: attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
96: attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
97: attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
98: attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
99: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
100: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
93: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
94: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
95: attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
96: attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
97: attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
98: attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
99: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
100: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
101: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
94: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
95: attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
96: attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
97: attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
98: attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
99: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
100: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
101: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
102: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
95: attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
96: attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
97: attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
98: attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
99: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
100: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
101: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
102: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
103: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
96: attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
97: attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
98: attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
99: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
100: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
101: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
102: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
103: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
104: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
97: attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
98: attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
99: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
100: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
101: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
102: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
103: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
104: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
105: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
98: attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
99: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
100: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
101: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
102: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
103: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
104: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
105: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
106: attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
99: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
100: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
101: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
102: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
103: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
104: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
105: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
106: attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
107: cancelled_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
100: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
101: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
102: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
103: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
104: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
105: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
106: attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
107: cancelled_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
108: cancelled_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
101: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
102: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
103: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
104: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
105: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
106: attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
107: cancelled_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
108: cancelled_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
109: carrier_id NUMBER DEFAULT FND_API.G_MISS_NUM,
102: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
103: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
104: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
105: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
106: attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
107: cancelled_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
108: cancelled_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
109: carrier_id NUMBER DEFAULT FND_API.G_MISS_NUM,
110: classification VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
103: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
104: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
105: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
106: attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
107: cancelled_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
108: cancelled_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
109: carrier_id NUMBER DEFAULT FND_API.G_MISS_NUM,
110: classification VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
111: commodity_code_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
104: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
105: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
106: attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
107: cancelled_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
108: cancelled_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
109: carrier_id NUMBER DEFAULT FND_API.G_MISS_NUM,
110: classification VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
111: commodity_code_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
112: container_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
105: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
106: attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
107: cancelled_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
108: cancelled_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
109: carrier_id NUMBER DEFAULT FND_API.G_MISS_NUM,
110: classification VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
111: commodity_code_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
112: container_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
113: container_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
106: attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
107: cancelled_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
108: cancelled_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
109: carrier_id NUMBER DEFAULT FND_API.G_MISS_NUM,
110: classification VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
111: commodity_code_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
112: container_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
113: container_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
114: container_type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
107: cancelled_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
108: cancelled_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
109: carrier_id NUMBER DEFAULT FND_API.G_MISS_NUM,
110: classification VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
111: commodity_code_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
112: container_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
113: container_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
114: container_type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
115: country_of_origin VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
108: cancelled_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
109: carrier_id NUMBER DEFAULT FND_API.G_MISS_NUM,
110: classification VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
111: commodity_code_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
112: container_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
113: container_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
114: container_type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
115: country_of_origin VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
116: currency_code VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
109: carrier_id NUMBER DEFAULT FND_API.G_MISS_NUM,
110: classification VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
111: commodity_code_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
112: container_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
113: container_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
114: container_type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
115: country_of_origin VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
116: currency_code VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
117: cust_model_serial_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
110: classification VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
111: commodity_code_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
112: container_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
113: container_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
114: container_type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
115: country_of_origin VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
116: currency_code VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
117: cust_model_serial_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
118: cust_po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
111: commodity_code_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
112: container_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
113: container_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
114: container_type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
115: country_of_origin VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
116: currency_code VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
117: cust_model_serial_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
118: cust_po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
119: customer_dock_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
112: container_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
113: container_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
114: container_type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
115: country_of_origin VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
116: currency_code VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
117: cust_model_serial_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
118: cust_po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
119: customer_dock_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
120: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
113: container_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
114: container_type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
115: country_of_origin VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
116: currency_code VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
117: cust_model_serial_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
118: cust_po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
119: customer_dock_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
120: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
121: customer_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
114: container_type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
115: country_of_origin VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
116: currency_code VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
117: cust_model_serial_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
118: cust_po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
119: customer_dock_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
120: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
121: customer_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
122: customer_job VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
115: country_of_origin VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
116: currency_code VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
117: cust_model_serial_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
118: cust_po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
119: customer_dock_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
120: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
121: customer_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
122: customer_job VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
123: customer_number NUMBER DEFAULT FND_API.G_MISS_NUM,
116: currency_code VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
117: cust_model_serial_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
118: cust_po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
119: customer_dock_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
120: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
121: customer_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
122: customer_job VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
123: customer_number NUMBER DEFAULT FND_API.G_MISS_NUM,
124: customer_prod_seq VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
117: cust_model_serial_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
118: cust_po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
119: customer_dock_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
120: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
121: customer_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
122: customer_job VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
123: customer_number NUMBER DEFAULT FND_API.G_MISS_NUM,
124: customer_prod_seq VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
125: customer_production_line VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
118: cust_po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
119: customer_dock_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
120: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
121: customer_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
122: customer_job VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
123: customer_number NUMBER DEFAULT FND_API.G_MISS_NUM,
124: customer_prod_seq VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
125: customer_production_line VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
126: customer_requested_lot_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
119: customer_dock_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
120: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
121: customer_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
122: customer_job VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
123: customer_number NUMBER DEFAULT FND_API.G_MISS_NUM,
124: customer_prod_seq VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
125: customer_production_line VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
126: customer_requested_lot_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
127: cycle_count_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
120: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
121: customer_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
122: customer_job VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
123: customer_number NUMBER DEFAULT FND_API.G_MISS_NUM,
124: customer_prod_seq VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
125: customer_production_line VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
126: customer_requested_lot_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
127: cycle_count_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
128: cycle_count_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
121: customer_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
122: customer_job VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
123: customer_number NUMBER DEFAULT FND_API.G_MISS_NUM,
124: customer_prod_seq VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
125: customer_production_line VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
126: customer_requested_lot_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
127: cycle_count_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
128: cycle_count_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
129: date_requested DATE DEFAULT FND_API.G_MISS_DATE,
122: customer_job VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
123: customer_number NUMBER DEFAULT FND_API.G_MISS_NUM,
124: customer_prod_seq VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
125: customer_production_line VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
126: customer_requested_lot_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
127: cycle_count_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
128: cycle_count_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
129: date_requested DATE DEFAULT FND_API.G_MISS_DATE,
130: date_scheduled DATE DEFAULT FND_API.G_MISS_DATE,
123: customer_number NUMBER DEFAULT FND_API.G_MISS_NUM,
124: customer_prod_seq VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
125: customer_production_line VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
126: customer_requested_lot_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
127: cycle_count_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
128: cycle_count_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
129: date_requested DATE DEFAULT FND_API.G_MISS_DATE,
130: date_scheduled DATE DEFAULT FND_API.G_MISS_DATE,
131: deliver_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
124: customer_prod_seq VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
125: customer_production_line VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
126: customer_requested_lot_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
127: cycle_count_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
128: cycle_count_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
129: date_requested DATE DEFAULT FND_API.G_MISS_DATE,
130: date_scheduled DATE DEFAULT FND_API.G_MISS_DATE,
131: deliver_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
132: deliver_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
125: customer_production_line VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
126: customer_requested_lot_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
127: cycle_count_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
128: cycle_count_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
129: date_requested DATE DEFAULT FND_API.G_MISS_DATE,
130: date_scheduled DATE DEFAULT FND_API.G_MISS_DATE,
131: deliver_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
132: deliver_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
133: deliver_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
126: customer_requested_lot_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
127: cycle_count_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
128: cycle_count_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
129: date_requested DATE DEFAULT FND_API.G_MISS_DATE,
130: date_scheduled DATE DEFAULT FND_API.G_MISS_DATE,
131: deliver_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
132: deliver_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
133: deliver_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
134: delivered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
127: cycle_count_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
128: cycle_count_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
129: date_requested DATE DEFAULT FND_API.G_MISS_DATE,
130: date_scheduled DATE DEFAULT FND_API.G_MISS_DATE,
131: deliver_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
132: deliver_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
133: deliver_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
134: delivered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
135: delivered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
128: cycle_count_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
129: date_requested DATE DEFAULT FND_API.G_MISS_DATE,
130: date_scheduled DATE DEFAULT FND_API.G_MISS_DATE,
131: deliver_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
132: deliver_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
133: deliver_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
134: delivered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
135: delivered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
136: delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
129: date_requested DATE DEFAULT FND_API.G_MISS_DATE,
130: date_scheduled DATE DEFAULT FND_API.G_MISS_DATE,
131: deliver_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
132: deliver_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
133: deliver_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
134: delivered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
135: delivered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
136: delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
137: dep_plan_required_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
130: date_scheduled DATE DEFAULT FND_API.G_MISS_DATE,
131: deliver_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
132: deliver_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
133: deliver_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
134: delivered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
135: delivered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
136: delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
137: dep_plan_required_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
138: detail_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
131: deliver_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
132: deliver_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
133: deliver_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
134: delivered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
135: delivered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
136: delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
137: dep_plan_required_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
138: detail_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
139: fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
132: deliver_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
133: deliver_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
134: delivered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
135: delivered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
136: delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
137: dep_plan_required_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
138: detail_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
139: fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
140: fob_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
133: deliver_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
134: delivered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
135: delivered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
136: delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
137: dep_plan_required_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
138: detail_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
139: fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
140: fob_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
141: fob_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
134: delivered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
135: delivered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
136: delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
137: dep_plan_required_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
138: detail_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
139: fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
140: fob_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
141: fob_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
142: freight_carrier_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
135: delivered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
136: delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
137: dep_plan_required_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
138: detail_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
139: fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
140: fob_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
141: fob_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
142: freight_carrier_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
143: freight_class_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
136: delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
137: dep_plan_required_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
138: detail_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
139: fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
140: fob_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
141: fob_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
142: freight_carrier_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
143: freight_class_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
144: freight_terms_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
137: dep_plan_required_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
138: detail_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
139: fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
140: fob_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
141: fob_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
142: freight_carrier_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
143: freight_class_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
144: freight_terms_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
145: freight_terms_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
138: detail_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
139: fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
140: fob_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
141: fob_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
142: freight_carrier_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
143: freight_class_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
144: freight_terms_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
145: freight_terms_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
146: gross_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
139: fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
140: fob_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
141: fob_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
142: freight_carrier_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
143: freight_class_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
144: freight_terms_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
145: freight_terms_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
146: gross_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
147: hazard_class_id NUMBER DEFAULT FND_API.G_MISS_NUM,
140: fob_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
141: fob_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
142: freight_carrier_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
143: freight_class_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
144: freight_terms_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
145: freight_terms_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
146: gross_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
147: hazard_class_id NUMBER DEFAULT FND_API.G_MISS_NUM,
148: hold_code VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
141: fob_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
142: freight_carrier_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
143: freight_class_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
144: freight_terms_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
145: freight_terms_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
146: gross_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
147: hazard_class_id NUMBER DEFAULT FND_API.G_MISS_NUM,
148: hold_code VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
149: inspection_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
142: freight_carrier_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
143: freight_class_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
144: freight_terms_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
145: freight_terms_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
146: gross_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
147: hazard_class_id NUMBER DEFAULT FND_API.G_MISS_NUM,
148: hold_code VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
149: inspection_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
150: intmed_ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
143: freight_class_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
144: freight_terms_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
145: freight_terms_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
146: gross_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
147: hazard_class_id NUMBER DEFAULT FND_API.G_MISS_NUM,
148: hold_code VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
149: inspection_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
150: intmed_ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
151: intmed_ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
144: freight_terms_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
145: freight_terms_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
146: gross_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
147: hazard_class_id NUMBER DEFAULT FND_API.G_MISS_NUM,
148: hold_code VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
149: inspection_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
150: intmed_ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
151: intmed_ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
152: intmed_ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
145: freight_terms_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
146: gross_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
147: hazard_class_id NUMBER DEFAULT FND_API.G_MISS_NUM,
148: hold_code VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
149: inspection_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
150: intmed_ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
151: intmed_ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
152: intmed_ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
153: inv_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
146: gross_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
147: hazard_class_id NUMBER DEFAULT FND_API.G_MISS_NUM,
148: hold_code VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
149: inspection_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
150: intmed_ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
151: intmed_ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
152: intmed_ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
153: inv_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
154: inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
147: hazard_class_id NUMBER DEFAULT FND_API.G_MISS_NUM,
148: hold_code VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
149: inspection_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
150: intmed_ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
151: intmed_ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
152: intmed_ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
153: inv_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
154: inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
155: item_description VARCHAR2(250) DEFAULT FND_API.G_MISS_CHAR,
148: hold_code VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
149: inspection_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
150: intmed_ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
151: intmed_ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
152: intmed_ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
153: inv_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
154: inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
155: item_description VARCHAR2(250) DEFAULT FND_API.G_MISS_CHAR,
156: line_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
149: inspection_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
150: intmed_ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
151: intmed_ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
152: intmed_ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
153: inv_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
154: inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
155: item_description VARCHAR2(250) DEFAULT FND_API.G_MISS_CHAR,
156: line_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
157: load_seq_number NUMBER DEFAULT FND_API.G_MISS_NUM,
150: intmed_ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
151: intmed_ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
152: intmed_ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
153: inv_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
154: inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
155: item_description VARCHAR2(250) DEFAULT FND_API.G_MISS_CHAR,
156: line_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
157: load_seq_number NUMBER DEFAULT FND_API.G_MISS_NUM,
158: locator_id NUMBER DEFAULT FND_API.G_MISS_NUM,
151: intmed_ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
152: intmed_ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
153: inv_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
154: inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
155: item_description VARCHAR2(250) DEFAULT FND_API.G_MISS_CHAR,
156: line_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
157: load_seq_number NUMBER DEFAULT FND_API.G_MISS_NUM,
158: locator_id NUMBER DEFAULT FND_API.G_MISS_NUM,
159: lot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
152: intmed_ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
153: inv_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
154: inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
155: item_description VARCHAR2(250) DEFAULT FND_API.G_MISS_CHAR,
156: line_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
157: load_seq_number NUMBER DEFAULT FND_API.G_MISS_NUM,
158: locator_id NUMBER DEFAULT FND_API.G_MISS_NUM,
159: lot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
160: lpn_content_id NUMBER DEFAULT FND_API.G_MISS_NUM,
153: inv_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
154: inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
155: item_description VARCHAR2(250) DEFAULT FND_API.G_MISS_CHAR,
156: line_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
157: load_seq_number NUMBER DEFAULT FND_API.G_MISS_NUM,
158: locator_id NUMBER DEFAULT FND_API.G_MISS_NUM,
159: lot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
160: lpn_content_id NUMBER DEFAULT FND_API.G_MISS_NUM,
161: lpn_id NUMBER DEFAULT FND_API.G_MISS_NUM,
154: inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
155: item_description VARCHAR2(250) DEFAULT FND_API.G_MISS_CHAR,
156: line_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
157: load_seq_number NUMBER DEFAULT FND_API.G_MISS_NUM,
158: locator_id NUMBER DEFAULT FND_API.G_MISS_NUM,
159: lot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
160: lpn_content_id NUMBER DEFAULT FND_API.G_MISS_NUM,
161: lpn_id NUMBER DEFAULT FND_API.G_MISS_NUM,
162: master_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
155: item_description VARCHAR2(250) DEFAULT FND_API.G_MISS_CHAR,
156: line_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
157: load_seq_number NUMBER DEFAULT FND_API.G_MISS_NUM,
158: locator_id NUMBER DEFAULT FND_API.G_MISS_NUM,
159: lot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
160: lpn_content_id NUMBER DEFAULT FND_API.G_MISS_NUM,
161: lpn_id NUMBER DEFAULT FND_API.G_MISS_NUM,
162: master_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
163: master_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
156: line_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
157: load_seq_number NUMBER DEFAULT FND_API.G_MISS_NUM,
158: locator_id NUMBER DEFAULT FND_API.G_MISS_NUM,
159: lot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
160: lpn_content_id NUMBER DEFAULT FND_API.G_MISS_NUM,
161: lpn_id NUMBER DEFAULT FND_API.G_MISS_NUM,
162: master_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
163: master_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
164: maximum_load_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
157: load_seq_number NUMBER DEFAULT FND_API.G_MISS_NUM,
158: locator_id NUMBER DEFAULT FND_API.G_MISS_NUM,
159: lot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
160: lpn_content_id NUMBER DEFAULT FND_API.G_MISS_NUM,
161: lpn_id NUMBER DEFAULT FND_API.G_MISS_NUM,
162: master_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
163: master_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
164: maximum_load_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
165: maximum_volume NUMBER DEFAULT FND_API.G_MISS_NUM,
158: locator_id NUMBER DEFAULT FND_API.G_MISS_NUM,
159: lot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
160: lpn_content_id NUMBER DEFAULT FND_API.G_MISS_NUM,
161: lpn_id NUMBER DEFAULT FND_API.G_MISS_NUM,
162: master_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
163: master_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
164: maximum_load_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
165: maximum_volume NUMBER DEFAULT FND_API.G_MISS_NUM,
166: minimum_fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
159: lot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
160: lpn_content_id NUMBER DEFAULT FND_API.G_MISS_NUM,
161: lpn_id NUMBER DEFAULT FND_API.G_MISS_NUM,
162: master_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
163: master_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
164: maximum_load_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
165: maximum_volume NUMBER DEFAULT FND_API.G_MISS_NUM,
166: minimum_fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
167: move_order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
160: lpn_content_id NUMBER DEFAULT FND_API.G_MISS_NUM,
161: lpn_id NUMBER DEFAULT FND_API.G_MISS_NUM,
162: master_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
163: master_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
164: maximum_load_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
165: maximum_volume NUMBER DEFAULT FND_API.G_MISS_NUM,
166: minimum_fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
167: move_order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
168: movement_id NUMBER DEFAULT FND_API.G_MISS_NUM,
161: lpn_id NUMBER DEFAULT FND_API.G_MISS_NUM,
162: master_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
163: master_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
164: maximum_load_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
165: maximum_volume NUMBER DEFAULT FND_API.G_MISS_NUM,
166: minimum_fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
167: move_order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
168: movement_id NUMBER DEFAULT FND_API.G_MISS_NUM,
169: mvt_stat_status VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
162: master_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
163: master_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
164: maximum_load_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
165: maximum_volume NUMBER DEFAULT FND_API.G_MISS_NUM,
166: minimum_fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
167: move_order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
168: movement_id NUMBER DEFAULT FND_API.G_MISS_NUM,
169: mvt_stat_status VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
170: net_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
163: master_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
164: maximum_load_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
165: maximum_volume NUMBER DEFAULT FND_API.G_MISS_NUM,
166: minimum_fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
167: move_order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
168: movement_id NUMBER DEFAULT FND_API.G_MISS_NUM,
169: mvt_stat_status VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
170: net_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
171: oe_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
164: maximum_load_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
165: maximum_volume NUMBER DEFAULT FND_API.G_MISS_NUM,
166: minimum_fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
167: move_order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
168: movement_id NUMBER DEFAULT FND_API.G_MISS_NUM,
169: mvt_stat_status VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
170: net_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
171: oe_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
172: order_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
165: maximum_volume NUMBER DEFAULT FND_API.G_MISS_NUM,
166: minimum_fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
167: move_order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
168: movement_id NUMBER DEFAULT FND_API.G_MISS_NUM,
169: mvt_stat_status VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
170: net_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
171: oe_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
172: order_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
173: ordered_qty_unit_of_measure VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
166: minimum_fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
167: move_order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
168: movement_id NUMBER DEFAULT FND_API.G_MISS_NUM,
169: mvt_stat_status VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
170: net_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
171: oe_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
172: order_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
173: ordered_qty_unit_of_measure VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
174: ordered_qty_unit_of_measure2 VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
167: move_order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
168: movement_id NUMBER DEFAULT FND_API.G_MISS_NUM,
169: mvt_stat_status VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
170: net_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
171: oe_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
172: order_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
173: ordered_qty_unit_of_measure VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
174: ordered_qty_unit_of_measure2 VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
175: ordered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
168: movement_id NUMBER DEFAULT FND_API.G_MISS_NUM,
169: mvt_stat_status VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
170: net_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
171: oe_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
172: order_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
173: ordered_qty_unit_of_measure VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
174: ordered_qty_unit_of_measure2 VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
175: ordered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
176: ordered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
169: mvt_stat_status VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
170: net_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
171: oe_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
172: order_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
173: ordered_qty_unit_of_measure VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
174: ordered_qty_unit_of_measure2 VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
175: ordered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
176: ordered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
177: ordered_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
170: net_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
171: oe_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
172: order_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
173: ordered_qty_unit_of_measure VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
174: ordered_qty_unit_of_measure2 VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
175: ordered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
176: ordered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
177: ordered_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
178: org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
171: oe_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
172: order_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
173: ordered_qty_unit_of_measure VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
174: ordered_qty_unit_of_measure2 VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
175: ordered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
176: ordered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
177: ordered_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
178: org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
179: organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,
172: order_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
173: ordered_qty_unit_of_measure VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
174: ordered_qty_unit_of_measure2 VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
175: ordered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
176: ordered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
177: ordered_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
178: org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
179: organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,
180: original_subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
173: ordered_qty_unit_of_measure VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
174: ordered_qty_unit_of_measure2 VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
175: ordered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
176: ordered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
177: ordered_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
178: org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
179: organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,
180: original_subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
181: packing_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
174: ordered_qty_unit_of_measure2 VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
175: ordered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
176: ordered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
177: ordered_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
178: org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
179: organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,
180: original_subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
181: packing_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
182: pickable_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
175: ordered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
176: ordered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
177: ordered_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
178: org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
179: organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,
180: original_subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
181: packing_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
182: pickable_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
183: picked_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
176: ordered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
177: ordered_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
178: org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
179: organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,
180: original_subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
181: packing_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
182: pickable_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
183: picked_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
184: picked_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
177: ordered_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
178: org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
179: organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,
180: original_subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
181: packing_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
182: pickable_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
183: picked_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
184: picked_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
185: preferred_grade VARCHAR2(4) DEFAULT FND_API.G_MISS_CHAR,
178: org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
179: organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,
180: original_subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
181: packing_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
182: pickable_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
183: picked_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
184: picked_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
185: preferred_grade VARCHAR2(4) DEFAULT FND_API.G_MISS_CHAR,
186: project_id NUMBER DEFAULT FND_API.G_MISS_NUM,
179: organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,
180: original_subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
181: packing_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
182: pickable_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
183: picked_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
184: picked_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
185: preferred_grade VARCHAR2(4) DEFAULT FND_API.G_MISS_CHAR,
186: project_id NUMBER DEFAULT FND_API.G_MISS_NUM,
187: quality_control_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
180: original_subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
181: packing_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
182: pickable_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
183: picked_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
184: picked_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
185: preferred_grade VARCHAR2(4) DEFAULT FND_API.G_MISS_CHAR,
186: project_id NUMBER DEFAULT FND_API.G_MISS_NUM,
187: quality_control_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
188: quality_control_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
181: packing_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
182: pickable_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
183: picked_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
184: picked_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
185: preferred_grade VARCHAR2(4) DEFAULT FND_API.G_MISS_CHAR,
186: project_id NUMBER DEFAULT FND_API.G_MISS_NUM,
187: quality_control_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
188: quality_control_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
189: released_status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
182: pickable_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
183: picked_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
184: picked_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
185: preferred_grade VARCHAR2(4) DEFAULT FND_API.G_MISS_CHAR,
186: project_id NUMBER DEFAULT FND_API.G_MISS_NUM,
187: quality_control_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
188: quality_control_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
189: released_status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
190: request_id NUMBER DEFAULT FND_API.G_MISS_NUM,
183: picked_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
184: picked_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
185: preferred_grade VARCHAR2(4) DEFAULT FND_API.G_MISS_CHAR,
186: project_id NUMBER DEFAULT FND_API.G_MISS_NUM,
187: quality_control_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
188: quality_control_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
189: released_status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
190: request_id NUMBER DEFAULT FND_API.G_MISS_NUM,
191: revision VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
184: picked_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
185: preferred_grade VARCHAR2(4) DEFAULT FND_API.G_MISS_CHAR,
186: project_id NUMBER DEFAULT FND_API.G_MISS_NUM,
187: quality_control_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
188: quality_control_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
189: released_status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
190: request_id NUMBER DEFAULT FND_API.G_MISS_NUM,
191: revision VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
192: seal_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
185: preferred_grade VARCHAR2(4) DEFAULT FND_API.G_MISS_CHAR,
186: project_id NUMBER DEFAULT FND_API.G_MISS_NUM,
187: quality_control_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
188: quality_control_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
189: released_status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
190: request_id NUMBER DEFAULT FND_API.G_MISS_NUM,
191: revision VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
192: seal_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
193: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
186: project_id NUMBER DEFAULT FND_API.G_MISS_NUM,
187: quality_control_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
188: quality_control_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
189: released_status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
190: request_id NUMBER DEFAULT FND_API.G_MISS_NUM,
191: revision VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
192: seal_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
193: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
194: ship_from_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
187: quality_control_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
188: quality_control_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
189: released_status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
190: request_id NUMBER DEFAULT FND_API.G_MISS_NUM,
191: revision VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
192: seal_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
193: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
194: ship_from_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
195: ship_from_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
188: quality_control_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
189: released_status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
190: request_id NUMBER DEFAULT FND_API.G_MISS_NUM,
191: revision VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
192: seal_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
193: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
194: ship_from_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
195: ship_from_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
196: ship_model_complete_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
189: released_status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
190: request_id NUMBER DEFAULT FND_API.G_MISS_NUM,
191: revision VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
192: seal_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
193: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
194: ship_from_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
195: ship_from_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
196: ship_model_complete_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
197: ship_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,
190: request_id NUMBER DEFAULT FND_API.G_MISS_NUM,
191: revision VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
192: seal_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
193: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
194: ship_from_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
195: ship_from_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
196: ship_model_complete_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
197: ship_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,
198: ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
191: revision VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
192: seal_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
193: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
194: ship_from_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
195: ship_from_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
196: ship_model_complete_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
197: ship_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,
198: ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
199: ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
192: seal_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
193: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
194: ship_from_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
195: ship_from_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
196: ship_model_complete_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
197: ship_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,
198: ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
199: ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
200: ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
193: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
194: ship_from_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
195: ship_from_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
196: ship_model_complete_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
197: ship_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,
198: ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
199: ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
200: ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
201: ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
194: ship_from_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
195: ship_from_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
196: ship_model_complete_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
197: ship_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,
198: ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
199: ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
200: ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
201: ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
202: ship_tolerance_above NUMBER DEFAULT FND_API.G_MISS_NUM,
195: ship_from_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
196: ship_model_complete_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
197: ship_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,
198: ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
199: ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
200: ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
201: ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
202: ship_tolerance_above NUMBER DEFAULT FND_API.G_MISS_NUM,
203: ship_tolerance_below NUMBER DEFAULT FND_API.G_MISS_NUM,
196: ship_model_complete_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
197: ship_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,
198: ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
199: ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
200: ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
201: ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
202: ship_tolerance_above NUMBER DEFAULT FND_API.G_MISS_NUM,
203: ship_tolerance_below NUMBER DEFAULT FND_API.G_MISS_NUM,
204: shipment_priority_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
197: ship_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,
198: ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
199: ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
200: ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
201: ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
202: ship_tolerance_above NUMBER DEFAULT FND_API.G_MISS_NUM,
203: ship_tolerance_below NUMBER DEFAULT FND_API.G_MISS_NUM,
204: shipment_priority_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
205: shipped_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
198: ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
199: ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
200: ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
201: ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
202: ship_tolerance_above NUMBER DEFAULT FND_API.G_MISS_NUM,
203: ship_tolerance_below NUMBER DEFAULT FND_API.G_MISS_NUM,
204: shipment_priority_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
205: shipped_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
206: shipped_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
199: ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
200: ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
201: ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
202: ship_tolerance_above NUMBER DEFAULT FND_API.G_MISS_NUM,
203: ship_tolerance_below NUMBER DEFAULT FND_API.G_MISS_NUM,
204: shipment_priority_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
205: shipped_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
206: shipped_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
207: shipping_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
200: ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
201: ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
202: ship_tolerance_above NUMBER DEFAULT FND_API.G_MISS_NUM,
203: ship_tolerance_below NUMBER DEFAULT FND_API.G_MISS_NUM,
204: shipment_priority_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
205: shipped_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
206: shipped_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
207: shipping_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
208: shipping_method_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
201: ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
202: ship_tolerance_above NUMBER DEFAULT FND_API.G_MISS_NUM,
203: ship_tolerance_below NUMBER DEFAULT FND_API.G_MISS_NUM,
204: shipment_priority_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
205: shipped_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
206: shipped_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
207: shipping_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
208: shipping_method_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
209: sold_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
202: ship_tolerance_above NUMBER DEFAULT FND_API.G_MISS_NUM,
203: ship_tolerance_below NUMBER DEFAULT FND_API.G_MISS_NUM,
204: shipment_priority_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
205: shipped_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
206: shipped_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
207: shipping_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
208: shipping_method_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
209: sold_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
210: sold_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
203: ship_tolerance_below NUMBER DEFAULT FND_API.G_MISS_NUM,
204: shipment_priority_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
205: shipped_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
206: shipped_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
207: shipping_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
208: shipping_method_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
209: sold_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
210: sold_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
211: source_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
204: shipment_priority_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
205: shipped_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
206: shipped_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
207: shipping_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
208: shipping_method_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
209: sold_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
210: sold_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
211: source_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
212: source_header_id NUMBER DEFAULT FND_API.G_MISS_NUM,
205: shipped_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
206: shipped_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
207: shipping_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
208: shipping_method_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
209: sold_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
210: sold_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
211: source_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
212: source_header_id NUMBER DEFAULT FND_API.G_MISS_NUM,
213: source_header_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
206: shipped_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
207: shipping_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
208: shipping_method_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
209: sold_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
210: sold_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
211: source_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
212: source_header_id NUMBER DEFAULT FND_API.G_MISS_NUM,
213: source_header_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
214: source_header_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
207: shipping_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
208: shipping_method_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
209: sold_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
210: sold_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
211: source_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
212: source_header_id NUMBER DEFAULT FND_API.G_MISS_NUM,
213: source_header_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
214: source_header_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
215: source_header_type_name VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
208: shipping_method_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
209: sold_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
210: sold_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
211: source_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
212: source_header_id NUMBER DEFAULT FND_API.G_MISS_NUM,
213: source_header_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
214: source_header_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
215: source_header_type_name VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
216: source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
209: sold_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
210: sold_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
211: source_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
212: source_header_id NUMBER DEFAULT FND_API.G_MISS_NUM,
213: source_header_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
214: source_header_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
215: source_header_type_name VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
216: source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
217: split_from_delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
210: sold_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
211: source_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
212: source_header_id NUMBER DEFAULT FND_API.G_MISS_NUM,
213: source_header_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
214: source_header_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
215: source_header_type_name VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
216: source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
217: split_from_delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
218: src_requested_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
211: source_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
212: source_header_id NUMBER DEFAULT FND_API.G_MISS_NUM,
213: source_header_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
214: source_header_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
215: source_header_type_name VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
216: source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
217: split_from_delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
218: src_requested_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
219: src_requested_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
212: source_header_id NUMBER DEFAULT FND_API.G_MISS_NUM,
213: source_header_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
214: source_header_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
215: source_header_type_name VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
216: source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
217: split_from_delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
218: src_requested_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
219: src_requested_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
220: src_requested_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
213: source_header_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
214: source_header_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
215: source_header_type_name VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
216: source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
217: split_from_delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
218: src_requested_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
219: src_requested_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
220: src_requested_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
221: src_requested_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
214: source_header_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
215: source_header_type_name VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
216: source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
217: split_from_delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
218: src_requested_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
219: src_requested_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
220: src_requested_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
221: src_requested_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
222: subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
215: source_header_type_name VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
216: source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
217: split_from_delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
218: src_requested_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
219: src_requested_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
220: src_requested_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
221: src_requested_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
222: subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
223: sublot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
216: source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
217: split_from_delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
218: src_requested_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
219: src_requested_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
220: src_requested_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
221: src_requested_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
222: subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
223: sublot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
224: task_id NUMBER DEFAULT FND_API.G_MISS_NUM,
217: split_from_delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
218: src_requested_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
219: src_requested_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
220: src_requested_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
221: src_requested_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
222: subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
223: sublot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
224: task_id NUMBER DEFAULT FND_API.G_MISS_NUM,
225: to_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
218: src_requested_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
219: src_requested_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
220: src_requested_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
221: src_requested_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
222: subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
223: sublot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
224: task_id NUMBER DEFAULT FND_API.G_MISS_NUM,
225: to_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
226: top_model_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
219: src_requested_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
220: src_requested_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
221: src_requested_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
222: subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
223: sublot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
224: task_id NUMBER DEFAULT FND_API.G_MISS_NUM,
225: to_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
226: top_model_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
227: tp_attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
220: src_requested_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
221: src_requested_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
222: subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
223: sublot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
224: task_id NUMBER DEFAULT FND_API.G_MISS_NUM,
225: to_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
226: top_model_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
227: tp_attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
228: tp_attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
221: src_requested_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
222: subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
223: sublot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
224: task_id NUMBER DEFAULT FND_API.G_MISS_NUM,
225: to_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
226: top_model_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
227: tp_attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
228: tp_attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
229: tp_attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
222: subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
223: sublot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
224: task_id NUMBER DEFAULT FND_API.G_MISS_NUM,
225: to_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
226: top_model_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
227: tp_attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
228: tp_attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
229: tp_attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
230: tp_attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
223: sublot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
224: task_id NUMBER DEFAULT FND_API.G_MISS_NUM,
225: to_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
226: top_model_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
227: tp_attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
228: tp_attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
229: tp_attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
230: tp_attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
231: tp_attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
224: task_id NUMBER DEFAULT FND_API.G_MISS_NUM,
225: to_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
226: top_model_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
227: tp_attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
228: tp_attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
229: tp_attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
230: tp_attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
231: tp_attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
232: tp_attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
225: to_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
226: top_model_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
227: tp_attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
228: tp_attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
229: tp_attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
230: tp_attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
231: tp_attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
232: tp_attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
233: tp_attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
226: top_model_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
227: tp_attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
228: tp_attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
229: tp_attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
230: tp_attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
231: tp_attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
232: tp_attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
233: tp_attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
234: tp_attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
227: tp_attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
228: tp_attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
229: tp_attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
230: tp_attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
231: tp_attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
232: tp_attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
233: tp_attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
234: tp_attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
235: tp_attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
228: tp_attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
229: tp_attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
230: tp_attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
231: tp_attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
232: tp_attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
233: tp_attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
234: tp_attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
235: tp_attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
236: tp_attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
229: tp_attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
230: tp_attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
231: tp_attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
232: tp_attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
233: tp_attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
234: tp_attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
235: tp_attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
236: tp_attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
237: tp_attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
230: tp_attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
231: tp_attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
232: tp_attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
233: tp_attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
234: tp_attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
235: tp_attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
236: tp_attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
237: tp_attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
238: tp_attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
231: tp_attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
232: tp_attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
233: tp_attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
234: tp_attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
235: tp_attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
236: tp_attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
237: tp_attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
238: tp_attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
239: tp_attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
232: tp_attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
233: tp_attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
234: tp_attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
235: tp_attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
236: tp_attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
237: tp_attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
238: tp_attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
239: tp_attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
240: tp_attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
233: tp_attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
234: tp_attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
235: tp_attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
236: tp_attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
237: tp_attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
238: tp_attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
239: tp_attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
240: tp_attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
241: tp_attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
234: tp_attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
235: tp_attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
236: tp_attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
237: tp_attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
238: tp_attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
239: tp_attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
240: tp_attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
241: tp_attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
242: tp_attribute_category VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
235: tp_attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
236: tp_attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
237: tp_attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
238: tp_attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
239: tp_attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
240: tp_attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
241: tp_attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
242: tp_attribute_category VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
243: tracking_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
236: tp_attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
237: tp_attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
238: tp_attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
239: tp_attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
240: tp_attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
241: tp_attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
242: tp_attribute_category VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
243: tracking_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
244: transaction_temp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
237: tp_attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
238: tp_attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
239: tp_attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
240: tp_attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
241: tp_attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
242: tp_attribute_category VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
243: tracking_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
244: transaction_temp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
245: unit_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
238: tp_attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
239: tp_attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
240: tp_attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
241: tp_attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
242: tp_attribute_category VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
243: tracking_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
244: transaction_temp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
245: unit_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
246: unit_price NUMBER DEFAULT FND_API.G_MISS_NUM,
239: tp_attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
240: tp_attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
241: tp_attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
242: tp_attribute_category VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
243: tracking_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
244: transaction_temp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
245: unit_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
246: unit_price NUMBER DEFAULT FND_API.G_MISS_NUM,
247: volume NUMBER DEFAULT FND_API.G_MISS_NUM,
240: tp_attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
241: tp_attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
242: tp_attribute_category VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
243: tracking_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
244: transaction_temp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
245: unit_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
246: unit_price NUMBER DEFAULT FND_API.G_MISS_NUM,
247: volume NUMBER DEFAULT FND_API.G_MISS_NUM,
248: volume_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
241: tp_attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
242: tp_attribute_category VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
243: tracking_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
244: transaction_temp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
245: unit_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
246: unit_price NUMBER DEFAULT FND_API.G_MISS_NUM,
247: volume NUMBER DEFAULT FND_API.G_MISS_NUM,
248: volume_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
249: volume_uom_desc VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
242: tp_attribute_category VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
243: tracking_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
244: transaction_temp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
245: unit_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
246: unit_price NUMBER DEFAULT FND_API.G_MISS_NUM,
247: volume NUMBER DEFAULT FND_API.G_MISS_NUM,
248: volume_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
249: volume_uom_desc VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
250: weight_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
243: tracking_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
244: transaction_temp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
245: unit_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
246: unit_price NUMBER DEFAULT FND_API.G_MISS_NUM,
247: volume NUMBER DEFAULT FND_API.G_MISS_NUM,
248: volume_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
249: volume_uom_desc VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
250: weight_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
251: weight_uom_desc VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR
244: transaction_temp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
245: unit_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
246: unit_price NUMBER DEFAULT FND_API.G_MISS_NUM,
247: volume NUMBER DEFAULT FND_API.G_MISS_NUM,
248: volume_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
249: volume_uom_desc VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
250: weight_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
251: weight_uom_desc VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR
252: );
245: unit_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
246: unit_price NUMBER DEFAULT FND_API.G_MISS_NUM,
247: volume NUMBER DEFAULT FND_API.G_MISS_NUM,
248: volume_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
249: volume_uom_desc VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
250: weight_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
251: weight_uom_desc VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR
252: );
253:
246: unit_price NUMBER DEFAULT FND_API.G_MISS_NUM,
247: volume NUMBER DEFAULT FND_API.G_MISS_NUM,
248: volume_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
249: volume_uom_desc VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
250: weight_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
251: weight_uom_desc VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR
252: );
253:
254: TYPE ChangedAttributeTabType IS TABLE OF ChangedAttributeRecType
247: volume NUMBER DEFAULT FND_API.G_MISS_NUM,
248: volume_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
249: volume_uom_desc VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
250: weight_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
251: weight_uom_desc VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR
252: );
253:
254: TYPE ChangedAttributeTabType IS TABLE OF ChangedAttributeRecType
255: INDEX BY BINARY_INTEGER;*/