eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_INTERFACE dependencies on FND_API

Line 15: action_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,

11: TYPE ChangedAttributeRecType IS RECORD -- This record now includes all the columns
12: -- other than the WHO columns in wsh_delivery_details,
13: -- it is also now sorted.
14: (
15: action_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
16: arrival_set_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
17: ato_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
18: attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
19: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,

Line 16: arrival_set_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

12: -- other than the WHO columns in wsh_delivery_details,
13: -- it is also now sorted.
14: (
15: action_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
16: arrival_set_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
17: ato_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
18: attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
19: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
20: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,

Line 17: ato_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

13: -- it is also now sorted.
14: (
15: action_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
16: arrival_set_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
17: ato_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
18: attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
19: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
20: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
21: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,

Line 18: attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,

14: (
15: action_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
16: arrival_set_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
17: ato_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
18: attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
19: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
20: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
21: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
22: attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,

Line 19: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,

15: action_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
16: arrival_set_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
17: ato_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
18: attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
19: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
20: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
21: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
22: attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
23: attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,

Line 20: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,

16: arrival_set_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
17: ato_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
18: attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
19: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
20: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
21: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
22: attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
23: attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
24: attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,

Line 21: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,

17: ato_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
18: attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
19: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
20: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
21: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
22: attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
23: attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
24: attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
25: attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,

Line 22: attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,

18: attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
19: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
20: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
21: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
22: attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
23: attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
24: attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
25: attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
26: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,

Line 23: attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,

19: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
20: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
21: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
22: attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
23: attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
24: attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
25: attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
26: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
27: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,

Line 24: attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,

20: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
21: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
22: attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
23: attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
24: attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
25: attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
26: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
27: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
28: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,

Line 25: attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,

21: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
22: attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
23: attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
24: attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
25: attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
26: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
27: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
28: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
29: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,

Line 26: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,

22: attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
23: attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
24: attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
25: attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
26: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
27: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
28: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
29: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
30: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,

Line 27: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,

23: attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
24: attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
25: attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
26: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
27: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
28: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
29: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
30: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
31: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,

Line 28: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,

24: attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
25: attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
26: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
27: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
28: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
29: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
30: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
31: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
32: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,

Line 29: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,

25: attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
26: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
27: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
28: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
29: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
30: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
31: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
32: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
33: attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,

Line 30: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,

26: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
27: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
28: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
29: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
30: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
31: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
32: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
33: attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
34: cancelled_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 31: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,

27: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
28: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
29: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
30: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
31: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
32: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
33: attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
34: cancelled_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
35: cancelled_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 32: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,

28: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
29: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
30: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
31: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
32: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
33: attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
34: cancelled_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
35: cancelled_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
36: carrier_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

Line 33: attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,

29: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
30: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
31: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
32: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
33: attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
34: cancelled_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
35: cancelled_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
36: carrier_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
37: classification VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

Line 34: cancelled_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,

30: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
31: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
32: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
33: attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
34: cancelled_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
35: cancelled_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
36: carrier_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
37: classification VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
38: commodity_code_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 35: cancelled_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,

31: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
32: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
33: attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
34: cancelled_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
35: cancelled_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
36: carrier_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
37: classification VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
38: commodity_code_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
39: container_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,

Line 36: carrier_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

32: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
33: attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
34: cancelled_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
35: cancelled_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
36: carrier_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
37: classification VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
38: commodity_code_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
39: container_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
40: container_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

Line 37: classification VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

33: attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
34: cancelled_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
35: cancelled_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
36: carrier_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
37: classification VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
38: commodity_code_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
39: container_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
40: container_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
41: container_type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

Line 38: commodity_code_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,

34: cancelled_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
35: cancelled_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
36: carrier_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
37: classification VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
38: commodity_code_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
39: container_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
40: container_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
41: container_type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
42: country_of_origin VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 39: container_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,

35: cancelled_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
36: carrier_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
37: classification VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
38: commodity_code_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
39: container_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
40: container_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
41: container_type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
42: country_of_origin VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
43: currency_code VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR ,

Line 40: container_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

36: carrier_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
37: classification VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
38: commodity_code_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
39: container_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
40: container_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
41: container_type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
42: country_of_origin VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
43: currency_code VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR ,
44: cust_model_serial_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,

Line 41: container_type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

37: classification VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
38: commodity_code_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
39: container_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
40: container_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
41: container_type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
42: country_of_origin VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
43: currency_code VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR ,
44: cust_model_serial_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
45: cust_po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR ,

Line 42: country_of_origin VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

38: commodity_code_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
39: container_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
40: container_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
41: container_type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
42: country_of_origin VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
43: currency_code VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR ,
44: cust_model_serial_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
45: cust_po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR ,
46: customer_dock_code VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR ,

Line 43: currency_code VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR ,

39: container_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
40: container_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
41: container_type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
42: country_of_origin VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
43: currency_code VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR ,
44: cust_model_serial_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
45: cust_po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR ,
46: customer_dock_code VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR ,
47: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 44: cust_model_serial_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,

40: container_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
41: container_type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
42: country_of_origin VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
43: currency_code VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR ,
44: cust_model_serial_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
45: cust_po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR ,
46: customer_dock_code VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR ,
47: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
48: customer_item_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

Line 45: cust_po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR ,

41: container_type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
42: country_of_origin VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
43: currency_code VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR ,
44: cust_model_serial_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
45: cust_po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR ,
46: customer_dock_code VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR ,
47: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
48: customer_item_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
49: customer_job VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,

Line 46: customer_dock_code VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR ,

42: country_of_origin VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
43: currency_code VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR ,
44: cust_model_serial_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
45: cust_po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR ,
46: customer_dock_code VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR ,
47: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
48: customer_item_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
49: customer_job VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
50: customer_prod_seq VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR ,

Line 47: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,

43: currency_code VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR ,
44: cust_model_serial_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
45: cust_po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR ,
46: customer_dock_code VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR ,
47: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
48: customer_item_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
49: customer_job VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
50: customer_prod_seq VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR ,
51: customer_production_line VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,

Line 48: customer_item_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

44: cust_model_serial_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
45: cust_po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR ,
46: customer_dock_code VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR ,
47: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
48: customer_item_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
49: customer_job VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
50: customer_prod_seq VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR ,
51: customer_production_line VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
52: customer_requested_lot_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,

Line 49: customer_job VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,

45: cust_po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR ,
46: customer_dock_code VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR ,
47: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
48: customer_item_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
49: customer_job VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
50: customer_prod_seq VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR ,
51: customer_production_line VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
52: customer_requested_lot_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
53: cycle_count_quantity NUMBER DEFAULT FND_API.G_MISS_NUM , -- added for Backordering

Line 50: customer_prod_seq VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR ,

46: customer_dock_code VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR ,
47: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
48: customer_item_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
49: customer_job VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
50: customer_prod_seq VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR ,
51: customer_production_line VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
52: customer_requested_lot_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
53: cycle_count_quantity NUMBER DEFAULT FND_API.G_MISS_NUM , -- added for Backordering
54: cycle_count_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM ,

Line 51: customer_production_line VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,

47: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
48: customer_item_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
49: customer_job VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
50: customer_prod_seq VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR ,
51: customer_production_line VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
52: customer_requested_lot_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
53: cycle_count_quantity NUMBER DEFAULT FND_API.G_MISS_NUM , -- added for Backordering
54: cycle_count_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM ,
55: date_requested DATE DEFAULT FND_API.G_MISS_DATE ,

Line 52: customer_requested_lot_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,

48: customer_item_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
49: customer_job VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
50: customer_prod_seq VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR ,
51: customer_production_line VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
52: customer_requested_lot_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
53: cycle_count_quantity NUMBER DEFAULT FND_API.G_MISS_NUM , -- added for Backordering
54: cycle_count_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM ,
55: date_requested DATE DEFAULT FND_API.G_MISS_DATE ,
56: date_scheduled DATE DEFAULT FND_API.G_MISS_DATE ,

Line 53: cycle_count_quantity NUMBER DEFAULT FND_API.G_MISS_NUM , -- added for Backordering

49: customer_job VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
50: customer_prod_seq VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR ,
51: customer_production_line VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
52: customer_requested_lot_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
53: cycle_count_quantity NUMBER DEFAULT FND_API.G_MISS_NUM , -- added for Backordering
54: cycle_count_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM ,
55: date_requested DATE DEFAULT FND_API.G_MISS_DATE ,
56: date_scheduled DATE DEFAULT FND_API.G_MISS_DATE ,
57: deliver_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

Line 54: cycle_count_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM ,

50: customer_prod_seq VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR ,
51: customer_production_line VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
52: customer_requested_lot_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
53: cycle_count_quantity NUMBER DEFAULT FND_API.G_MISS_NUM , -- added for Backordering
54: cycle_count_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM ,
55: date_requested DATE DEFAULT FND_API.G_MISS_DATE ,
56: date_scheduled DATE DEFAULT FND_API.G_MISS_DATE ,
57: deliver_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
58: deliver_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

Line 55: date_requested DATE DEFAULT FND_API.G_MISS_DATE ,

51: customer_production_line VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
52: customer_requested_lot_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
53: cycle_count_quantity NUMBER DEFAULT FND_API.G_MISS_NUM , -- added for Backordering
54: cycle_count_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM ,
55: date_requested DATE DEFAULT FND_API.G_MISS_DATE ,
56: date_scheduled DATE DEFAULT FND_API.G_MISS_DATE ,
57: deliver_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
58: deliver_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
59: delivered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 56: date_scheduled DATE DEFAULT FND_API.G_MISS_DATE ,

52: customer_requested_lot_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
53: cycle_count_quantity NUMBER DEFAULT FND_API.G_MISS_NUM , -- added for Backordering
54: cycle_count_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM ,
55: date_requested DATE DEFAULT FND_API.G_MISS_DATE ,
56: date_scheduled DATE DEFAULT FND_API.G_MISS_DATE ,
57: deliver_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
58: deliver_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
59: delivered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
60: delivered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 57: deliver_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

53: cycle_count_quantity NUMBER DEFAULT FND_API.G_MISS_NUM , -- added for Backordering
54: cycle_count_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM ,
55: date_requested DATE DEFAULT FND_API.G_MISS_DATE ,
56: date_scheduled DATE DEFAULT FND_API.G_MISS_DATE ,
57: deliver_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
58: deliver_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
59: delivered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
60: delivered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
61: delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

Line 58: deliver_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

54: cycle_count_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM ,
55: date_requested DATE DEFAULT FND_API.G_MISS_DATE ,
56: date_scheduled DATE DEFAULT FND_API.G_MISS_DATE ,
57: deliver_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
58: deliver_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
59: delivered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
60: delivered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
61: delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
62: dep_plan_required_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,

Line 59: delivered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,

55: date_requested DATE DEFAULT FND_API.G_MISS_DATE ,
56: date_scheduled DATE DEFAULT FND_API.G_MISS_DATE ,
57: deliver_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
58: deliver_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
59: delivered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
60: delivered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
61: delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
62: dep_plan_required_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
63: detail_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

Line 60: delivered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,

56: date_scheduled DATE DEFAULT FND_API.G_MISS_DATE ,
57: deliver_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
58: deliver_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
59: delivered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
60: delivered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
61: delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
62: dep_plan_required_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
63: detail_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
64: fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 61: delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

57: deliver_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
58: deliver_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
59: delivered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
60: delivered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
61: delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
62: dep_plan_required_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
63: detail_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
64: fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
65: fob_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,

Line 62: dep_plan_required_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,

58: deliver_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
59: delivered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
60: delivered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
61: delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
62: dep_plan_required_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
63: detail_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
64: fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
65: fob_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
66: freight_carrier_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,

Line 63: detail_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

59: delivered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
60: delivered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
61: delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
62: dep_plan_required_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
63: detail_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
64: fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
65: fob_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
66: freight_carrier_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
67: freight_class_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 64: fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,

60: delivered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
61: delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
62: dep_plan_required_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
63: detail_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
64: fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
65: fob_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
66: freight_carrier_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
67: freight_class_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
68: freight_terms_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,

Line 65: fob_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,

61: delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
62: dep_plan_required_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
63: detail_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
64: fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
65: fob_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
66: freight_carrier_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
67: freight_class_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
68: freight_terms_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
69: gross_weight NUMBER DEFAULT FND_API.G_MISS_NUM ,

Line 66: freight_carrier_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,

62: dep_plan_required_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
63: detail_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
64: fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
65: fob_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
66: freight_carrier_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
67: freight_class_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
68: freight_terms_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
69: gross_weight NUMBER DEFAULT FND_API.G_MISS_NUM ,
70: hazard_class_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 67: freight_class_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,

63: detail_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
64: fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
65: fob_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
66: freight_carrier_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
67: freight_class_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
68: freight_terms_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
69: gross_weight NUMBER DEFAULT FND_API.G_MISS_NUM ,
70: hazard_class_id NUMBER DEFAULT FND_API.G_MISS_NUM,
71: hold_code VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,

Line 68: freight_terms_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,

64: fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
65: fob_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
66: freight_carrier_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
67: freight_class_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
68: freight_terms_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
69: gross_weight NUMBER DEFAULT FND_API.G_MISS_NUM ,
70: hazard_class_id NUMBER DEFAULT FND_API.G_MISS_NUM,
71: hold_code VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
72: inspection_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR , -- added for Contracts

Line 69: gross_weight NUMBER DEFAULT FND_API.G_MISS_NUM ,

65: fob_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
66: freight_carrier_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
67: freight_class_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
68: freight_terms_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
69: gross_weight NUMBER DEFAULT FND_API.G_MISS_NUM ,
70: hazard_class_id NUMBER DEFAULT FND_API.G_MISS_NUM,
71: hold_code VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
72: inspection_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR , -- added for Contracts
73: intmed_ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

Line 70: hazard_class_id NUMBER DEFAULT FND_API.G_MISS_NUM,

66: freight_carrier_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
67: freight_class_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
68: freight_terms_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
69: gross_weight NUMBER DEFAULT FND_API.G_MISS_NUM ,
70: hazard_class_id NUMBER DEFAULT FND_API.G_MISS_NUM,
71: hold_code VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
72: inspection_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR , -- added for Contracts
73: intmed_ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
74: intmed_ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

Line 71: hold_code VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,

67: freight_class_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
68: freight_terms_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
69: gross_weight NUMBER DEFAULT FND_API.G_MISS_NUM ,
70: hazard_class_id NUMBER DEFAULT FND_API.G_MISS_NUM,
71: hold_code VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
72: inspection_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR , -- added for Contracts
73: intmed_ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
74: intmed_ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
75: inv_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,

Line 72: inspection_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR , -- added for Contracts

68: freight_terms_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
69: gross_weight NUMBER DEFAULT FND_API.G_MISS_NUM ,
70: hazard_class_id NUMBER DEFAULT FND_API.G_MISS_NUM,
71: hold_code VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
72: inspection_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR , -- added for Contracts
73: intmed_ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
74: intmed_ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
75: inv_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
76: inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 73: intmed_ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

69: gross_weight NUMBER DEFAULT FND_API.G_MISS_NUM ,
70: hazard_class_id NUMBER DEFAULT FND_API.G_MISS_NUM,
71: hold_code VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
72: inspection_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR , -- added for Contracts
73: intmed_ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
74: intmed_ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
75: inv_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
76: inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
77: item_description VARCHAR2(250) DEFAULT FND_API.G_MISS_CHAR,

Line 74: intmed_ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

70: hazard_class_id NUMBER DEFAULT FND_API.G_MISS_NUM,
71: hold_code VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
72: inspection_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR , -- added for Contracts
73: intmed_ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
74: intmed_ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
75: inv_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
76: inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
77: item_description VARCHAR2(250) DEFAULT FND_API.G_MISS_CHAR,
78: item_type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,

Line 75: inv_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,

71: hold_code VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
72: inspection_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR , -- added for Contracts
73: intmed_ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
74: intmed_ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
75: inv_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
76: inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
77: item_description VARCHAR2(250) DEFAULT FND_API.G_MISS_CHAR,
78: item_type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
79: line_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR, -- Bug 1610845

Line 76: inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,

72: inspection_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR , -- added for Contracts
73: intmed_ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
74: intmed_ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
75: inv_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
76: inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
77: item_description VARCHAR2(250) DEFAULT FND_API.G_MISS_CHAR,
78: item_type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
79: line_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR, -- Bug 1610845
80: load_seq_number NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 77: item_description VARCHAR2(250) DEFAULT FND_API.G_MISS_CHAR,

73: intmed_ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
74: intmed_ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
75: inv_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
76: inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
77: item_description VARCHAR2(250) DEFAULT FND_API.G_MISS_CHAR,
78: item_type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
79: line_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR, -- Bug 1610845
80: load_seq_number NUMBER DEFAULT FND_API.G_MISS_NUM,
81: locator_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

Line 78: item_type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,

74: intmed_ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
75: inv_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
76: inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
77: item_description VARCHAR2(250) DEFAULT FND_API.G_MISS_CHAR,
78: item_type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
79: line_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR, -- Bug 1610845
80: load_seq_number NUMBER DEFAULT FND_API.G_MISS_NUM,
81: locator_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
82: lot_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

Line 79: line_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR, -- Bug 1610845

75: inv_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
76: inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
77: item_description VARCHAR2(250) DEFAULT FND_API.G_MISS_CHAR,
78: item_type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
79: line_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR, -- Bug 1610845
80: load_seq_number NUMBER DEFAULT FND_API.G_MISS_NUM,
81: locator_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
82: lot_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
83: -- HW OPMCONV. Need to expand length of lot_number to 80

Line 80: load_seq_number NUMBER DEFAULT FND_API.G_MISS_NUM,

76: inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
77: item_description VARCHAR2(250) DEFAULT FND_API.G_MISS_CHAR,
78: item_type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
79: line_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR, -- Bug 1610845
80: load_seq_number NUMBER DEFAULT FND_API.G_MISS_NUM,
81: locator_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
82: lot_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
83: -- HW OPMCONV. Need to expand length of lot_number to 80
84: lot_number VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR ,

Line 81: locator_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

77: item_description VARCHAR2(250) DEFAULT FND_API.G_MISS_CHAR,
78: item_type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
79: line_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR, -- Bug 1610845
80: load_seq_number NUMBER DEFAULT FND_API.G_MISS_NUM,
81: locator_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
82: lot_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
83: -- HW OPMCONV. Need to expand length of lot_number to 80
84: lot_number VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR ,
85: lpn_content_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 82: lot_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

78: item_type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
79: line_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR, -- Bug 1610845
80: load_seq_number NUMBER DEFAULT FND_API.G_MISS_NUM,
81: locator_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
82: lot_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
83: -- HW OPMCONV. Need to expand length of lot_number to 80
84: lot_number VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR ,
85: lpn_content_id NUMBER DEFAULT FND_API.G_MISS_NUM,
86: lpn_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 84: lot_number VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR ,

80: load_seq_number NUMBER DEFAULT FND_API.G_MISS_NUM,
81: locator_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
82: lot_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
83: -- HW OPMCONV. Need to expand length of lot_number to 80
84: lot_number VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR ,
85: lpn_content_id NUMBER DEFAULT FND_API.G_MISS_NUM,
86: lpn_id NUMBER DEFAULT FND_API.G_MISS_NUM,
87: master_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
88: master_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

Line 85: lpn_content_id NUMBER DEFAULT FND_API.G_MISS_NUM,

81: locator_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
82: lot_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
83: -- HW OPMCONV. Need to expand length of lot_number to 80
84: lot_number VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR ,
85: lpn_content_id NUMBER DEFAULT FND_API.G_MISS_NUM,
86: lpn_id NUMBER DEFAULT FND_API.G_MISS_NUM,
87: master_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
88: master_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
89: maximum_load_weight NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 86: lpn_id NUMBER DEFAULT FND_API.G_MISS_NUM,

82: lot_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
83: -- HW OPMCONV. Need to expand length of lot_number to 80
84: lot_number VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR ,
85: lpn_content_id NUMBER DEFAULT FND_API.G_MISS_NUM,
86: lpn_id NUMBER DEFAULT FND_API.G_MISS_NUM,
87: master_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
88: master_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
89: maximum_load_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
90: maximum_volume NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 87: master_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

83: -- HW OPMCONV. Need to expand length of lot_number to 80
84: lot_number VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR ,
85: lpn_content_id NUMBER DEFAULT FND_API.G_MISS_NUM,
86: lpn_id NUMBER DEFAULT FND_API.G_MISS_NUM,
87: master_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
88: master_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
89: maximum_load_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
90: maximum_volume NUMBER DEFAULT FND_API.G_MISS_NUM,
91: minimum_fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 88: master_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

84: lot_number VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR ,
85: lpn_content_id NUMBER DEFAULT FND_API.G_MISS_NUM,
86: lpn_id NUMBER DEFAULT FND_API.G_MISS_NUM,
87: master_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
88: master_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
89: maximum_load_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
90: maximum_volume NUMBER DEFAULT FND_API.G_MISS_NUM,
91: minimum_fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
92: move_order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 89: maximum_load_weight NUMBER DEFAULT FND_API.G_MISS_NUM,

85: lpn_content_id NUMBER DEFAULT FND_API.G_MISS_NUM,
86: lpn_id NUMBER DEFAULT FND_API.G_MISS_NUM,
87: master_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
88: master_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
89: maximum_load_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
90: maximum_volume NUMBER DEFAULT FND_API.G_MISS_NUM,
91: minimum_fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
92: move_order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
93: movement_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 90: maximum_volume NUMBER DEFAULT FND_API.G_MISS_NUM,

86: lpn_id NUMBER DEFAULT FND_API.G_MISS_NUM,
87: master_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
88: master_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
89: maximum_load_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
90: maximum_volume NUMBER DEFAULT FND_API.G_MISS_NUM,
91: minimum_fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
92: move_order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
93: movement_id NUMBER DEFAULT FND_API.G_MISS_NUM,
94: mvt_stat_status VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

Line 91: minimum_fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,

87: master_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
88: master_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
89: maximum_load_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
90: maximum_volume NUMBER DEFAULT FND_API.G_MISS_NUM,
91: minimum_fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
92: move_order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
93: movement_id NUMBER DEFAULT FND_API.G_MISS_NUM,
94: mvt_stat_status VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
95: net_weight NUMBER DEFAULT FND_API.G_MISS_NUM ,

Line 92: move_order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,

88: master_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
89: maximum_load_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
90: maximum_volume NUMBER DEFAULT FND_API.G_MISS_NUM,
91: minimum_fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
92: move_order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
93: movement_id NUMBER DEFAULT FND_API.G_MISS_NUM,
94: mvt_stat_status VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
95: net_weight NUMBER DEFAULT FND_API.G_MISS_NUM ,
96: oe_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,

Line 93: movement_id NUMBER DEFAULT FND_API.G_MISS_NUM,

89: maximum_load_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
90: maximum_volume NUMBER DEFAULT FND_API.G_MISS_NUM,
91: minimum_fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
92: move_order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
93: movement_id NUMBER DEFAULT FND_API.G_MISS_NUM,
94: mvt_stat_status VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
95: net_weight NUMBER DEFAULT FND_API.G_MISS_NUM ,
96: oe_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
97: order_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,

Line 94: mvt_stat_status VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

90: maximum_volume NUMBER DEFAULT FND_API.G_MISS_NUM,
91: minimum_fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
92: move_order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
93: movement_id NUMBER DEFAULT FND_API.G_MISS_NUM,
94: mvt_stat_status VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
95: net_weight NUMBER DEFAULT FND_API.G_MISS_NUM ,
96: oe_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
97: order_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,
98: ordered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM ,

Line 95: net_weight NUMBER DEFAULT FND_API.G_MISS_NUM ,

91: minimum_fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
92: move_order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
93: movement_id NUMBER DEFAULT FND_API.G_MISS_NUM,
94: mvt_stat_status VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
95: net_weight NUMBER DEFAULT FND_API.G_MISS_NUM ,
96: oe_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
97: order_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,
98: ordered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM ,
99: ordered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM ,

Line 96: oe_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,

92: move_order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
93: movement_id NUMBER DEFAULT FND_API.G_MISS_NUM,
94: mvt_stat_status VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
95: net_weight NUMBER DEFAULT FND_API.G_MISS_NUM ,
96: oe_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
97: order_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,
98: ordered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM ,
99: ordered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM ,
100: ordered_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,

Line 97: order_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,

93: movement_id NUMBER DEFAULT FND_API.G_MISS_NUM,
94: mvt_stat_status VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
95: net_weight NUMBER DEFAULT FND_API.G_MISS_NUM ,
96: oe_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
97: order_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,
98: ordered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM ,
99: ordered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM ,
100: ordered_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,
101: org_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 98: ordered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM ,

94: mvt_stat_status VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
95: net_weight NUMBER DEFAULT FND_API.G_MISS_NUM ,
96: oe_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
97: order_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,
98: ordered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM ,
99: ordered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM ,
100: ordered_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,
101: org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
102: organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 99: ordered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM ,

95: net_weight NUMBER DEFAULT FND_API.G_MISS_NUM ,
96: oe_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
97: order_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,
98: ordered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM ,
99: ordered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM ,
100: ordered_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,
101: org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
102: organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,
103: original_source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

Line 100: ordered_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,

96: oe_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
97: order_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,
98: ordered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM ,
99: ordered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM ,
100: ordered_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,
101: org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
102: organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,
103: original_source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
104: original_subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,

Line 101: org_id NUMBER DEFAULT FND_API.G_MISS_NUM,

97: order_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,
98: ordered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM ,
99: ordered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM ,
100: ordered_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,
101: org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
102: organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,
103: original_source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
104: original_subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
105: packing_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR ,

Line 102: organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,

98: ordered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM ,
99: ordered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM ,
100: ordered_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,
101: org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
102: organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,
103: original_source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
104: original_subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
105: packing_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR ,
106: pending_quantity NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530

Line 103: original_source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

99: ordered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM ,
100: ordered_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,
101: org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
102: organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,
103: original_source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
104: original_subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
105: packing_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR ,
106: pending_quantity NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530
107: pending_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530

Line 104: original_subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,

100: ordered_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,
101: org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
102: organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,
103: original_source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
104: original_subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
105: packing_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR ,
106: pending_quantity NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530
107: pending_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530
108: pickable_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,

Line 105: packing_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR ,

101: org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
102: organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,
103: original_source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
104: original_subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
105: packing_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR ,
106: pending_quantity NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530
107: pending_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530
108: pickable_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
109: picked_quantity NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530

Line 106: pending_quantity NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530

102: organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,
103: original_source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
104: original_subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
105: packing_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR ,
106: pending_quantity NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530
107: pending_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530
108: pickable_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
109: picked_quantity NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530
110: picked_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530

Line 107: pending_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530

103: original_source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
104: original_subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
105: packing_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR ,
106: pending_quantity NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530
107: pending_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530
108: pickable_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
109: picked_quantity NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530
110: picked_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530
111: -- HW OPMCONV. Need to expand length of grade to 150

Line 108: pickable_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,

104: original_subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
105: packing_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR ,
106: pending_quantity NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530
107: pending_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530
108: pickable_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
109: picked_quantity NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530
110: picked_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530
111: -- HW OPMCONV. Need to expand length of grade to 150
112: preferred_grade VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,

Line 109: picked_quantity NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530

105: packing_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR ,
106: pending_quantity NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530
107: pending_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530
108: pickable_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
109: picked_quantity NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530
110: picked_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530
111: -- HW OPMCONV. Need to expand length of grade to 150
112: preferred_grade VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
113: project_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 110: picked_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530

106: pending_quantity NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530
107: pending_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530
108: pickable_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
109: picked_quantity NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530
110: picked_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530
111: -- HW OPMCONV. Need to expand length of grade to 150
112: preferred_grade VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
113: project_id NUMBER DEFAULT FND_API.G_MISS_NUM,
114: quality_control_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 112: preferred_grade VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,

108: pickable_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
109: picked_quantity NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530
110: picked_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530
111: -- HW OPMCONV. Need to expand length of grade to 150
112: preferred_grade VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
113: project_id NUMBER DEFAULT FND_API.G_MISS_NUM,
114: quality_control_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
115: quality_control_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
116: received_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 113: project_id NUMBER DEFAULT FND_API.G_MISS_NUM,

109: picked_quantity NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530
110: picked_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530
111: -- HW OPMCONV. Need to expand length of grade to 150
112: preferred_grade VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
113: project_id NUMBER DEFAULT FND_API.G_MISS_NUM,
114: quality_control_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
115: quality_control_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
116: received_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
117: received_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 114: quality_control_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,

110: picked_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530
111: -- HW OPMCONV. Need to expand length of grade to 150
112: preferred_grade VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
113: project_id NUMBER DEFAULT FND_API.G_MISS_NUM,
114: quality_control_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
115: quality_control_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
116: received_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
117: received_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
118: released_status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,

Line 115: quality_control_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,

111: -- HW OPMCONV. Need to expand length of grade to 150
112: preferred_grade VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
113: project_id NUMBER DEFAULT FND_API.G_MISS_NUM,
114: quality_control_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
115: quality_control_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
116: received_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
117: received_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
118: released_status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
119: request_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 116: received_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,

112: preferred_grade VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
113: project_id NUMBER DEFAULT FND_API.G_MISS_NUM,
114: quality_control_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
115: quality_control_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
116: received_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
117: received_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
118: released_status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
119: request_id NUMBER DEFAULT FND_API.G_MISS_NUM,
120: revision VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,

Line 117: received_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,

113: project_id NUMBER DEFAULT FND_API.G_MISS_NUM,
114: quality_control_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
115: quality_control_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
116: received_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
117: received_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
118: released_status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
119: request_id NUMBER DEFAULT FND_API.G_MISS_NUM,
120: revision VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,
121: seal_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

Line 118: released_status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,

114: quality_control_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
115: quality_control_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
116: received_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
117: received_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
118: released_status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
119: request_id NUMBER DEFAULT FND_API.G_MISS_NUM,
120: revision VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,
121: seal_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
122: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,

Line 119: request_id NUMBER DEFAULT FND_API.G_MISS_NUM,

115: quality_control_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
116: received_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
117: received_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
118: released_status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
119: request_id NUMBER DEFAULT FND_API.G_MISS_NUM,
120: revision VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,
121: seal_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
122: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
123: ship_from_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

Line 120: revision VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,

116: received_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
117: received_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
118: released_status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
119: request_id NUMBER DEFAULT FND_API.G_MISS_NUM,
120: revision VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,
121: seal_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
122: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
123: ship_from_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
124: ship_model_complete_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,

Line 121: seal_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

117: received_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
118: released_status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
119: request_id NUMBER DEFAULT FND_API.G_MISS_NUM,
120: revision VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,
121: seal_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
122: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
123: ship_from_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
124: ship_model_complete_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
125: ship_set_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

Line 122: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,

118: released_status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
119: request_id NUMBER DEFAULT FND_API.G_MISS_NUM,
120: revision VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,
121: seal_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
122: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
123: ship_from_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
124: ship_model_complete_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
125: ship_set_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
126: ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

Line 123: ship_from_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

119: request_id NUMBER DEFAULT FND_API.G_MISS_NUM,
120: revision VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,
121: seal_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
122: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
123: ship_from_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
124: ship_model_complete_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
125: ship_set_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
126: ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
127: ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

Line 124: ship_model_complete_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,

120: revision VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,
121: seal_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
122: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
123: ship_from_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
124: ship_model_complete_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
125: ship_set_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
126: ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
127: ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
128: ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 125: ship_set_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

121: seal_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
122: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
123: ship_from_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
124: ship_model_complete_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
125: ship_set_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
126: ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
127: ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
128: ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
129: ship_tolerance_above NUMBER DEFAULT FND_API.G_MISS_NUM ,

Line 126: ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

122: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
123: ship_from_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
124: ship_model_complete_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
125: ship_set_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
126: ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
127: ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
128: ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
129: ship_tolerance_above NUMBER DEFAULT FND_API.G_MISS_NUM ,
130: ship_tolerance_below NUMBER DEFAULT FND_API.G_MISS_NUM ,

Line 127: ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

123: ship_from_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
124: ship_model_complete_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
125: ship_set_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
126: ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
127: ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
128: ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
129: ship_tolerance_above NUMBER DEFAULT FND_API.G_MISS_NUM ,
130: ship_tolerance_below NUMBER DEFAULT FND_API.G_MISS_NUM ,
131: shipment_priority_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,

Line 128: ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,

124: ship_model_complete_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
125: ship_set_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
126: ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
127: ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
128: ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
129: ship_tolerance_above NUMBER DEFAULT FND_API.G_MISS_NUM ,
130: ship_tolerance_below NUMBER DEFAULT FND_API.G_MISS_NUM ,
131: shipment_priority_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
132: shipped_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,

Line 129: ship_tolerance_above NUMBER DEFAULT FND_API.G_MISS_NUM ,

125: ship_set_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
126: ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
127: ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
128: ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
129: ship_tolerance_above NUMBER DEFAULT FND_API.G_MISS_NUM ,
130: ship_tolerance_below NUMBER DEFAULT FND_API.G_MISS_NUM ,
131: shipment_priority_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
132: shipped_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
133: shipped_quantity NUMBER DEFAULT FND_API.G_MISS_NUM ,

Line 130: ship_tolerance_below NUMBER DEFAULT FND_API.G_MISS_NUM ,

126: ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
127: ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
128: ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
129: ship_tolerance_above NUMBER DEFAULT FND_API.G_MISS_NUM ,
130: ship_tolerance_below NUMBER DEFAULT FND_API.G_MISS_NUM ,
131: shipment_priority_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
132: shipped_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
133: shipped_quantity NUMBER DEFAULT FND_API.G_MISS_NUM ,
134: shipped_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM ,

Line 131: shipment_priority_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,

127: ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
128: ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
129: ship_tolerance_above NUMBER DEFAULT FND_API.G_MISS_NUM ,
130: ship_tolerance_below NUMBER DEFAULT FND_API.G_MISS_NUM ,
131: shipment_priority_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
132: shipped_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
133: shipped_quantity NUMBER DEFAULT FND_API.G_MISS_NUM ,
134: shipped_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM ,
135: shipping_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR ,

Line 132: shipped_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,

128: ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
129: ship_tolerance_above NUMBER DEFAULT FND_API.G_MISS_NUM ,
130: ship_tolerance_below NUMBER DEFAULT FND_API.G_MISS_NUM ,
131: shipment_priority_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
132: shipped_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
133: shipped_quantity NUMBER DEFAULT FND_API.G_MISS_NUM ,
134: shipped_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM ,
135: shipping_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR ,
136: shipping_method_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,

Line 133: shipped_quantity NUMBER DEFAULT FND_API.G_MISS_NUM ,

129: ship_tolerance_above NUMBER DEFAULT FND_API.G_MISS_NUM ,
130: ship_tolerance_below NUMBER DEFAULT FND_API.G_MISS_NUM ,
131: shipment_priority_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
132: shipped_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
133: shipped_quantity NUMBER DEFAULT FND_API.G_MISS_NUM ,
134: shipped_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM ,
135: shipping_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR ,
136: shipping_method_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
137: sold_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

Line 134: shipped_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM ,

130: ship_tolerance_below NUMBER DEFAULT FND_API.G_MISS_NUM ,
131: shipment_priority_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
132: shipped_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
133: shipped_quantity NUMBER DEFAULT FND_API.G_MISS_NUM ,
134: shipped_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM ,
135: shipping_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR ,
136: shipping_method_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
137: sold_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
138: sold_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

Line 135: shipping_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR ,

131: shipment_priority_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
132: shipped_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
133: shipped_quantity NUMBER DEFAULT FND_API.G_MISS_NUM ,
134: shipped_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM ,
135: shipping_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR ,
136: shipping_method_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
137: sold_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
138: sold_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
139: source_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

Line 136: shipping_method_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,

132: shipped_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
133: shipped_quantity NUMBER DEFAULT FND_API.G_MISS_NUM ,
134: shipped_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM ,
135: shipping_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR ,
136: shipping_method_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
137: sold_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
138: sold_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
139: source_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
140: source_header_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

Line 137: sold_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

133: shipped_quantity NUMBER DEFAULT FND_API.G_MISS_NUM ,
134: shipped_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM ,
135: shipping_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR ,
136: shipping_method_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
137: sold_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
138: sold_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
139: source_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
140: source_header_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
141: source_header_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 138: sold_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

134: shipped_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM ,
135: shipping_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR ,
136: shipping_method_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
137: sold_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
138: sold_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
139: source_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
140: source_header_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
141: source_header_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
142: source_header_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 139: source_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

135: shipping_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR ,
136: shipping_method_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
137: sold_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
138: sold_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
139: source_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
140: source_header_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
141: source_header_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
142: source_header_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
143: source_header_type_name VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,

Line 140: source_header_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

136: shipping_method_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
137: sold_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
138: sold_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
139: source_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
140: source_header_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
141: source_header_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
142: source_header_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
143: source_header_type_name VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
144: source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

Line 141: source_header_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

137: sold_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
138: sold_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
139: source_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
140: source_header_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
141: source_header_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
142: source_header_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
143: source_header_type_name VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
144: source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
145: source_line_set_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

Line 142: source_header_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,

138: sold_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
139: source_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
140: source_header_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
141: source_header_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
142: source_header_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
143: source_header_type_name VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
144: source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
145: source_line_set_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
146: split_from_delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 143: source_header_type_name VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,

139: source_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
140: source_header_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
141: source_header_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
142: source_header_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
143: source_header_type_name VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
144: source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
145: source_line_set_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
146: split_from_delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
147: src_requested_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 144: source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

140: source_header_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
141: source_header_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
142: source_header_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
143: source_header_type_name VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
144: source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
145: source_line_set_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
146: split_from_delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
147: src_requested_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
148: src_requested_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 145: source_line_set_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

141: source_header_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
142: source_header_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
143: source_header_type_name VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
144: source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
145: source_line_set_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
146: split_from_delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
147: src_requested_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
148: src_requested_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
149: src_requested_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,

Line 146: split_from_delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,

142: source_header_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
143: source_header_type_name VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
144: source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
145: source_line_set_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
146: split_from_delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
147: src_requested_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
148: src_requested_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
149: src_requested_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
150: src_requested_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,

Line 147: src_requested_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,

143: source_header_type_name VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
144: source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
145: source_line_set_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
146: split_from_delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
147: src_requested_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
148: src_requested_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
149: src_requested_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
150: src_requested_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
151: subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR ,

Line 148: src_requested_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,

144: source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
145: source_line_set_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
146: split_from_delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
147: src_requested_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
148: src_requested_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
149: src_requested_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
150: src_requested_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
151: subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR ,
152: -- HW OPMCONV. No need for sublot anymore

Line 149: src_requested_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,

145: source_line_set_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
146: split_from_delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
147: src_requested_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
148: src_requested_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
149: src_requested_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
150: src_requested_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
151: subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR ,
152: -- HW OPMCONV. No need for sublot anymore
153: -- sublot_number VARCHAR2(32) DEFAULT FND_API.G_MISS_CHAR ,

Line 150: src_requested_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,

146: split_from_delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
147: src_requested_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
148: src_requested_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
149: src_requested_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
150: src_requested_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
151: subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR ,
152: -- HW OPMCONV. No need for sublot anymore
153: -- sublot_number VARCHAR2(32) DEFAULT FND_API.G_MISS_CHAR ,
154: task_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 151: subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR ,

147: src_requested_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
148: src_requested_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
149: src_requested_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
150: src_requested_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
151: subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR ,
152: -- HW OPMCONV. No need for sublot anymore
153: -- sublot_number VARCHAR2(32) DEFAULT FND_API.G_MISS_CHAR ,
154: task_id NUMBER DEFAULT FND_API.G_MISS_NUM,
155: to_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

Line 153: -- sublot_number VARCHAR2(32) DEFAULT FND_API.G_MISS_CHAR ,

149: src_requested_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
150: src_requested_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
151: subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR ,
152: -- HW OPMCONV. No need for sublot anymore
153: -- sublot_number VARCHAR2(32) DEFAULT FND_API.G_MISS_CHAR ,
154: task_id NUMBER DEFAULT FND_API.G_MISS_NUM,
155: to_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
156: top_model_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
157: tp_attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,

Line 154: task_id NUMBER DEFAULT FND_API.G_MISS_NUM,

150: src_requested_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
151: subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR ,
152: -- HW OPMCONV. No need for sublot anymore
153: -- sublot_number VARCHAR2(32) DEFAULT FND_API.G_MISS_CHAR ,
154: task_id NUMBER DEFAULT FND_API.G_MISS_NUM,
155: to_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
156: top_model_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
157: tp_attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
158: tp_attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,

Line 155: to_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

151: subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR ,
152: -- HW OPMCONV. No need for sublot anymore
153: -- sublot_number VARCHAR2(32) DEFAULT FND_API.G_MISS_CHAR ,
154: task_id NUMBER DEFAULT FND_API.G_MISS_NUM,
155: to_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
156: top_model_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
157: tp_attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
158: tp_attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
159: tp_attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,

Line 156: top_model_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

152: -- HW OPMCONV. No need for sublot anymore
153: -- sublot_number VARCHAR2(32) DEFAULT FND_API.G_MISS_CHAR ,
154: task_id NUMBER DEFAULT FND_API.G_MISS_NUM,
155: to_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
156: top_model_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
157: tp_attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
158: tp_attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
159: tp_attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
160: tp_attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,

Line 157: tp_attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,

153: -- sublot_number VARCHAR2(32) DEFAULT FND_API.G_MISS_CHAR ,
154: task_id NUMBER DEFAULT FND_API.G_MISS_NUM,
155: to_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
156: top_model_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
157: tp_attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
158: tp_attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
159: tp_attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
160: tp_attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
161: tp_attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,

Line 158: tp_attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,

154: task_id NUMBER DEFAULT FND_API.G_MISS_NUM,
155: to_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
156: top_model_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
157: tp_attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
158: tp_attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
159: tp_attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
160: tp_attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
161: tp_attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
162: tp_attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,

Line 159: tp_attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,

155: to_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
156: top_model_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
157: tp_attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
158: tp_attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
159: tp_attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
160: tp_attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
161: tp_attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
162: tp_attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
163: tp_attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,

Line 160: tp_attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,

156: top_model_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
157: tp_attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
158: tp_attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
159: tp_attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
160: tp_attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
161: tp_attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
162: tp_attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
163: tp_attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
164: tp_attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,

Line 161: tp_attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,

157: tp_attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
158: tp_attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
159: tp_attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
160: tp_attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
161: tp_attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
162: tp_attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
163: tp_attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
164: tp_attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
165: tp_attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,

Line 162: tp_attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,

158: tp_attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
159: tp_attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
160: tp_attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
161: tp_attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
162: tp_attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
163: tp_attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
164: tp_attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
165: tp_attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
166: tp_attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,

Line 163: tp_attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,

159: tp_attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
160: tp_attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
161: tp_attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
162: tp_attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
163: tp_attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
164: tp_attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
165: tp_attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
166: tp_attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
167: tp_attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,

Line 164: tp_attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,

160: tp_attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
161: tp_attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
162: tp_attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
163: tp_attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
164: tp_attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
165: tp_attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
166: tp_attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
167: tp_attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
168: tp_attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,

Line 165: tp_attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,

161: tp_attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
162: tp_attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
163: tp_attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
164: tp_attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
165: tp_attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
166: tp_attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
167: tp_attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
168: tp_attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
169: tp_attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,

Line 166: tp_attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,

162: tp_attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
163: tp_attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
164: tp_attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
165: tp_attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
166: tp_attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
167: tp_attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
168: tp_attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
169: tp_attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
170: tp_attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,

Line 167: tp_attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,

163: tp_attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
164: tp_attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
165: tp_attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
166: tp_attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
167: tp_attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
168: tp_attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
169: tp_attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
170: tp_attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
171: tp_attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,

Line 168: tp_attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,

164: tp_attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
165: tp_attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
166: tp_attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
167: tp_attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
168: tp_attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
169: tp_attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
170: tp_attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
171: tp_attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
172: tp_attribute_category VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,

Line 169: tp_attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,

165: tp_attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
166: tp_attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
167: tp_attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
168: tp_attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
169: tp_attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
170: tp_attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
171: tp_attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
172: tp_attribute_category VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
173: tracking_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,

Line 170: tp_attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,

166: tp_attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
167: tp_attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
168: tp_attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
169: tp_attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
170: tp_attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
171: tp_attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
172: tp_attribute_category VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
173: tracking_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
174: trans_id NUMBER DEFAULT FND_API.G_MISS_NUM, -- NC OPM changes BUG #1636578

Line 171: tp_attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,

167: tp_attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
168: tp_attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
169: tp_attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
170: tp_attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
171: tp_attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
172: tp_attribute_category VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
173: tracking_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
174: trans_id NUMBER DEFAULT FND_API.G_MISS_NUM, -- NC OPM changes BUG #1636578
175: transaction_temp_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 172: tp_attribute_category VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,

168: tp_attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
169: tp_attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
170: tp_attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
171: tp_attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
172: tp_attribute_category VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
173: tracking_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
174: trans_id NUMBER DEFAULT FND_API.G_MISS_NUM, -- NC OPM changes BUG #1636578
175: transaction_temp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
176: transfer_lpn_id NUMBER DEFAULT FND_API.G_MISS_NUM , -- added for cross-docking

Line 173: tracking_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,

169: tp_attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
170: tp_attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
171: tp_attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
172: tp_attribute_category VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
173: tracking_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
174: trans_id NUMBER DEFAULT FND_API.G_MISS_NUM, -- NC OPM changes BUG #1636578
175: transaction_temp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
176: transfer_lpn_id NUMBER DEFAULT FND_API.G_MISS_NUM , -- added for cross-docking
177: unit_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

Line 174: trans_id NUMBER DEFAULT FND_API.G_MISS_NUM, -- NC OPM changes BUG #1636578

170: tp_attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
171: tp_attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
172: tp_attribute_category VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
173: tracking_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
174: trans_id NUMBER DEFAULT FND_API.G_MISS_NUM, -- NC OPM changes BUG #1636578
175: transaction_temp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
176: transfer_lpn_id NUMBER DEFAULT FND_API.G_MISS_NUM , -- added for cross-docking
177: unit_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
178: unit_price NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 175: transaction_temp_id NUMBER DEFAULT FND_API.G_MISS_NUM,

171: tp_attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
172: tp_attribute_category VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
173: tracking_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
174: trans_id NUMBER DEFAULT FND_API.G_MISS_NUM, -- NC OPM changes BUG #1636578
175: transaction_temp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
176: transfer_lpn_id NUMBER DEFAULT FND_API.G_MISS_NUM , -- added for cross-docking
177: unit_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
178: unit_price NUMBER DEFAULT FND_API.G_MISS_NUM,
179: volume NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 176: transfer_lpn_id NUMBER DEFAULT FND_API.G_MISS_NUM , -- added for cross-docking

172: tp_attribute_category VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
173: tracking_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
174: trans_id NUMBER DEFAULT FND_API.G_MISS_NUM, -- NC OPM changes BUG #1636578
175: transaction_temp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
176: transfer_lpn_id NUMBER DEFAULT FND_API.G_MISS_NUM , -- added for cross-docking
177: unit_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
178: unit_price NUMBER DEFAULT FND_API.G_MISS_NUM,
179: volume NUMBER DEFAULT FND_API.G_MISS_NUM,
180: volume_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,

Line 177: unit_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

173: tracking_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
174: trans_id NUMBER DEFAULT FND_API.G_MISS_NUM, -- NC OPM changes BUG #1636578
175: transaction_temp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
176: transfer_lpn_id NUMBER DEFAULT FND_API.G_MISS_NUM , -- added for cross-docking
177: unit_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
178: unit_price NUMBER DEFAULT FND_API.G_MISS_NUM,
179: volume NUMBER DEFAULT FND_API.G_MISS_NUM,
180: volume_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,
181: weight_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,

Line 178: unit_price NUMBER DEFAULT FND_API.G_MISS_NUM,

174: trans_id NUMBER DEFAULT FND_API.G_MISS_NUM, -- NC OPM changes BUG #1636578
175: transaction_temp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
176: transfer_lpn_id NUMBER DEFAULT FND_API.G_MISS_NUM , -- added for cross-docking
177: unit_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
178: unit_price NUMBER DEFAULT FND_API.G_MISS_NUM,
179: volume NUMBER DEFAULT FND_API.G_MISS_NUM,
180: volume_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,
181: weight_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
182: --added for calc. TP dates

Line 179: volume NUMBER DEFAULT FND_API.G_MISS_NUM,

175: transaction_temp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
176: transfer_lpn_id NUMBER DEFAULT FND_API.G_MISS_NUM , -- added for cross-docking
177: unit_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
178: unit_price NUMBER DEFAULT FND_API.G_MISS_NUM,
179: volume NUMBER DEFAULT FND_API.G_MISS_NUM,
180: volume_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,
181: weight_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
182: --added for calc. TP dates
183: latest_acceptable_date DATE DEFAULT FND_API.G_MISS_DATE ,

Line 180: volume_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,

176: transfer_lpn_id NUMBER DEFAULT FND_API.G_MISS_NUM , -- added for cross-docking
177: unit_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
178: unit_price NUMBER DEFAULT FND_API.G_MISS_NUM,
179: volume NUMBER DEFAULT FND_API.G_MISS_NUM,
180: volume_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,
181: weight_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
182: --added for calc. TP dates
183: latest_acceptable_date DATE DEFAULT FND_API.G_MISS_DATE ,
184: promise_date DATE DEFAULT FND_API.G_MISS_DATE ,

Line 181: weight_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,

177: unit_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
178: unit_price NUMBER DEFAULT FND_API.G_MISS_NUM,
179: volume NUMBER DEFAULT FND_API.G_MISS_NUM,
180: volume_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,
181: weight_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
182: --added for calc. TP dates
183: latest_acceptable_date DATE DEFAULT FND_API.G_MISS_DATE ,
184: promise_date DATE DEFAULT FND_API.G_MISS_DATE ,
185: schedule_arrival_date DATE DEFAULT FND_API.G_MISS_DATE ,

Line 183: latest_acceptable_date DATE DEFAULT FND_API.G_MISS_DATE ,

179: volume NUMBER DEFAULT FND_API.G_MISS_NUM,
180: volume_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,
181: weight_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
182: --added for calc. TP dates
183: latest_acceptable_date DATE DEFAULT FND_API.G_MISS_DATE ,
184: promise_date DATE DEFAULT FND_API.G_MISS_DATE ,
185: schedule_arrival_date DATE DEFAULT FND_API.G_MISS_DATE ,
186: earliest_acceptable_date DATE DEFAULT FND_API.G_MISS_DATE ,
187: earliest_ship_date DATE DEFAULT FND_API.G_MISS_DATE, --demand_satisfaction_date from TP

Line 184: promise_date DATE DEFAULT FND_API.G_MISS_DATE ,

180: volume_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,
181: weight_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
182: --added for calc. TP dates
183: latest_acceptable_date DATE DEFAULT FND_API.G_MISS_DATE ,
184: promise_date DATE DEFAULT FND_API.G_MISS_DATE ,
185: schedule_arrival_date DATE DEFAULT FND_API.G_MISS_DATE ,
186: earliest_acceptable_date DATE DEFAULT FND_API.G_MISS_DATE ,
187: earliest_ship_date DATE DEFAULT FND_API.G_MISS_DATE, --demand_satisfaction_date from TP
188: -- J: W/V Changes

Line 185: schedule_arrival_date DATE DEFAULT FND_API.G_MISS_DATE ,

181: weight_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
182: --added for calc. TP dates
183: latest_acceptable_date DATE DEFAULT FND_API.G_MISS_DATE ,
184: promise_date DATE DEFAULT FND_API.G_MISS_DATE ,
185: schedule_arrival_date DATE DEFAULT FND_API.G_MISS_DATE ,
186: earliest_acceptable_date DATE DEFAULT FND_API.G_MISS_DATE ,
187: earliest_ship_date DATE DEFAULT FND_API.G_MISS_DATE, --demand_satisfaction_date from TP
188: -- J: W/V Changes
189: filled_volume NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 186: earliest_acceptable_date DATE DEFAULT FND_API.G_MISS_DATE ,

182: --added for calc. TP dates
183: latest_acceptable_date DATE DEFAULT FND_API.G_MISS_DATE ,
184: promise_date DATE DEFAULT FND_API.G_MISS_DATE ,
185: schedule_arrival_date DATE DEFAULT FND_API.G_MISS_DATE ,
186: earliest_acceptable_date DATE DEFAULT FND_API.G_MISS_DATE ,
187: earliest_ship_date DATE DEFAULT FND_API.G_MISS_DATE, --demand_satisfaction_date from TP
188: -- J: W/V Changes
189: filled_volume NUMBER DEFAULT FND_API.G_MISS_NUM,
190: client_id NUMBER -- LSP PROJECT

Line 187: earliest_ship_date DATE DEFAULT FND_API.G_MISS_DATE, --demand_satisfaction_date from TP

183: latest_acceptable_date DATE DEFAULT FND_API.G_MISS_DATE ,
184: promise_date DATE DEFAULT FND_API.G_MISS_DATE ,
185: schedule_arrival_date DATE DEFAULT FND_API.G_MISS_DATE ,
186: earliest_acceptable_date DATE DEFAULT FND_API.G_MISS_DATE ,
187: earliest_ship_date DATE DEFAULT FND_API.G_MISS_DATE, --demand_satisfaction_date from TP
188: -- J: W/V Changes
189: filled_volume NUMBER DEFAULT FND_API.G_MISS_NUM,
190: client_id NUMBER -- LSP PROJECT
191: );

Line 189: filled_volume NUMBER DEFAULT FND_API.G_MISS_NUM,

185: schedule_arrival_date DATE DEFAULT FND_API.G_MISS_DATE ,
186: earliest_acceptable_date DATE DEFAULT FND_API.G_MISS_DATE ,
187: earliest_ship_date DATE DEFAULT FND_API.G_MISS_DATE, --demand_satisfaction_date from TP
188: -- J: W/V Changes
189: filled_volume NUMBER DEFAULT FND_API.G_MISS_NUM,
190: client_id NUMBER -- LSP PROJECT
191: );
192:
193: TYPE ChangedAttributeTabType IS TABLE OF ChangedAttributeRecType

Line 236: p_log_level IN NUMBER DEFAULT FND_API.G_MISS_NUM -- log level fix

232: PROCEDURE Update_Shipping_Attributes
233: (p_source_code IN VARCHAR2,
234: p_changed_attributes IN ChangedAttributeTabType,
235: x_return_status OUT NOCOPY VARCHAR2,
236: p_log_level IN NUMBER DEFAULT FND_API.G_MISS_NUM -- log level fix
237: );
238:
239: -- These procedures Get_In_Transit_Qty are for TPA.
240: -- Bug 1569962