DBA Data[Home] [Help]

APPS.OKL_LA_ASSET_PVT dependencies on OKC_K_LINES_B

Line 16: from_start_date OKC_K_LINES_B.START_DATE%TYPE,

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,

Line 17: from_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,

Line 18: from_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,

Line 19: to_start_date OKC_K_LINES_B.START_DATE%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),

Line 20: to_end_date OKC_K_LINES_B.END_DATE%TYPE,

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,

Line 21: to_date_terminated OKC_K_LINES_B.DATE_TERMINATED%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,
25: dnz_chr_id NUMBER := OKL_API.G_MISS_NUM,

Line 22: sts_code OKC_K_LINES_B.STS_CODE%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,
26: p_order_by VARCHAR2(10) := 'AST',

Line 57: start_date OKC_K_LINES_B.START_DATE%TYPE,

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),

Line 58: end_date OKC_K_LINES_B.END_DATE%TYPE,

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,

Line 59: date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE,

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,

Line 60: sts_code OKC_K_LINES_B.STS_CODE%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,
64: p_order_by VARCHAR2(10) := 'AST',