12: to_oec NUMBER := OKL_API.G_MISS_NUM,
13: vendor_name PO_VENDORS.VENDOR_NAME%TYPE,
14: from_residual_value NUMBER := OKL_API.G_MISS_NUM,
15: to_residual_value NUMBER := OKL_API.G_MISS_NUM,
16: from_start_date OKC_K_LINES_B.START_DATE%TYPE,
17: from_end_date OKC_K_LINES_B.END_DATE%TYPE,
18: from_date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE,
19: to_start_date OKC_K_LINES_B.START_DATE%TYPE,
20: to_end_date OKC_K_LINES_B.END_DATE%TYPE,
13: vendor_name PO_VENDORS.VENDOR_NAME%TYPE,
14: from_residual_value NUMBER := OKL_API.G_MISS_NUM,
15: to_residual_value NUMBER := OKL_API.G_MISS_NUM,
16: from_start_date OKC_K_LINES_B.START_DATE%TYPE,
17: from_end_date OKC_K_LINES_B.END_DATE%TYPE,
18: from_date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE,
19: to_start_date OKC_K_LINES_B.START_DATE%TYPE,
20: to_end_date OKC_K_LINES_B.END_DATE%TYPE,
21: to_date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE,
14: from_residual_value NUMBER := OKL_API.G_MISS_NUM,
15: to_residual_value NUMBER := OKL_API.G_MISS_NUM,
16: from_start_date OKC_K_LINES_B.START_DATE%TYPE,
17: from_end_date OKC_K_LINES_B.END_DATE%TYPE,
18: from_date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE,
19: to_start_date OKC_K_LINES_B.START_DATE%TYPE,
20: to_end_date OKC_K_LINES_B.END_DATE%TYPE,
21: to_date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE,
22: sts_code OKC_K_LINES_B.STS_CODE%TYPE,
15: to_residual_value NUMBER := OKL_API.G_MISS_NUM,
16: from_start_date OKC_K_LINES_B.START_DATE%TYPE,
17: from_end_date OKC_K_LINES_B.END_DATE%TYPE,
18: from_date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE,
19: to_start_date OKC_K_LINES_B.START_DATE%TYPE,
20: to_end_date OKC_K_LINES_B.END_DATE%TYPE,
21: to_date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE,
22: sts_code OKC_K_LINES_B.STS_CODE%TYPE,
23: location_id VARCHAR(1995),
16: from_start_date OKC_K_LINES_B.START_DATE%TYPE,
17: from_end_date OKC_K_LINES_B.END_DATE%TYPE,
18: from_date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE,
19: to_start_date OKC_K_LINES_B.START_DATE%TYPE,
20: to_end_date OKC_K_LINES_B.END_DATE%TYPE,
21: to_date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE,
22: sts_code OKC_K_LINES_B.STS_CODE%TYPE,
23: location_id VARCHAR(1995),
24: parent_line_id NUMBER := OKL_API.G_MISS_NUM,
17: from_end_date OKC_K_LINES_B.END_DATE%TYPE,
18: from_date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE,
19: to_start_date OKC_K_LINES_B.START_DATE%TYPE,
20: to_end_date OKC_K_LINES_B.END_DATE%TYPE,
21: to_date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE,
22: sts_code OKC_K_LINES_B.STS_CODE%TYPE,
23: location_id VARCHAR(1995),
24: parent_line_id NUMBER := OKL_API.G_MISS_NUM,
25: dnz_chr_id NUMBER := OKL_API.G_MISS_NUM,
18: from_date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE,
19: to_start_date OKC_K_LINES_B.START_DATE%TYPE,
20: to_end_date OKC_K_LINES_B.END_DATE%TYPE,
21: to_date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE,
22: sts_code OKC_K_LINES_B.STS_CODE%TYPE,
23: location_id VARCHAR(1995),
24: parent_line_id NUMBER := OKL_API.G_MISS_NUM,
25: dnz_chr_id NUMBER := OKL_API.G_MISS_NUM,
26: p_order_by VARCHAR2(10) := 'AST',
53: current_units NUMBER := OKL_API.G_MISS_NUM,
54: oec NUMBER := OKL_API.G_MISS_NUM,
55: vendor_name PO_VENDORS.VENDOR_NAME%TYPE,
56: residual_value NUMBER := OKL_API.G_MISS_NUM,
57: start_date OKC_K_LINES_B.START_DATE%TYPE,
58: end_date OKC_K_LINES_B.END_DATE%TYPE,
59: date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE,
60: sts_code OKC_K_LINES_B.STS_CODE%TYPE,
61: location_id VARCHAR(1995),
54: oec NUMBER := OKL_API.G_MISS_NUM,
55: vendor_name PO_VENDORS.VENDOR_NAME%TYPE,
56: residual_value NUMBER := OKL_API.G_MISS_NUM,
57: start_date OKC_K_LINES_B.START_DATE%TYPE,
58: end_date OKC_K_LINES_B.END_DATE%TYPE,
59: date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE,
60: sts_code OKC_K_LINES_B.STS_CODE%TYPE,
61: location_id VARCHAR(1995),
62: parent_line_id NUMBER := OKL_API.G_MISS_NUM,
55: vendor_name PO_VENDORS.VENDOR_NAME%TYPE,
56: residual_value NUMBER := OKL_API.G_MISS_NUM,
57: start_date OKC_K_LINES_B.START_DATE%TYPE,
58: end_date OKC_K_LINES_B.END_DATE%TYPE,
59: date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE,
60: sts_code OKC_K_LINES_B.STS_CODE%TYPE,
61: location_id VARCHAR(1995),
62: parent_line_id NUMBER := OKL_API.G_MISS_NUM,
63: dnz_chr_id NUMBER := OKL_API.G_MISS_NUM,
56: residual_value NUMBER := OKL_API.G_MISS_NUM,
57: start_date OKC_K_LINES_B.START_DATE%TYPE,
58: end_date OKC_K_LINES_B.END_DATE%TYPE,
59: date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE,
60: sts_code OKC_K_LINES_B.STS_CODE%TYPE,
61: location_id VARCHAR(1995),
62: parent_line_id NUMBER := OKL_API.G_MISS_NUM,
63: dnz_chr_id NUMBER := OKL_API.G_MISS_NUM,
64: p_order_by VARCHAR2(10) := 'AST',