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.OKL_CONTRACT_STATUS_PVT dependencies on OKC_K_HEADERS_B

Line 91: FROM okc_k_headers_b chr,

87: --cursor to check for vendor program template
88: CURSOR l_chk_template_csr (p_chr_id IN Number) IS
89: SELECT chr.template_yn,
90: khr.template_type_code
91: FROM okc_k_headers_b chr,
92: okl_k_headers khr
93: WHERE chr.id = p_chr_id
94: AND chr.id = khr.id;
95:

Line 230: okc_k_headers_b b,

226: b.template_yn template_yn,
227: --Bug# 4502754
228: c.template_type_code
229: from okc_statuses_v a,
230: okc_k_headers_b b,
231: okl_k_headers c
232: where a.code = b.sts_code
233: and b.id = c.id
234: and b.id = chrId;

Line 239: FROM OKC_K_HEADERS_B chr,

235:
236: CURSOR chr_csr(p_chr_id OKL_K_HEADERS.KHR_ID%TYPE) IS
237: SELECT chr.SCS_CODE class,
238: chr.STS_CODE okc_status
239: FROM OKC_K_HEADERS_B chr,
240: OKL_K_HEADERS khr
241: WHERE chr.id = p_chr_id
242: AND chr.id = khr.id;
243:

Line 250: ,okc_k_headers_b chr

246: ,pdt.name product_name
247: ,chr.sts_code okl_status
248: FROM okl_products_v pdt
249: ,okl_k_headers khr
250: ,okc_k_headers_b chr
251: WHERE 1=1
252: AND khr.id = p_contract_id
253: AND khr.pdt_id = pdt.id
254: AND khr.id = chr.id;

Line 494: FROM OKC_K_HEADERS_B

490: START_DATE,
491: END_DATE,
492: CURRENCY_CODE,
493: SCS_CODE
494: FROM OKC_K_HEADERS_B
495: WHERE ID = p_chr_id;
496:
497: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
498: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;

Line 497: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;

493: SCS_CODE
494: FROM OKC_K_HEADERS_B
495: WHERE ID = p_chr_id;
496:
497: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
498: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
499: l_khr_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
500: l_khr_currency OKC_K_HEADERS_B.CURRENCY_CODE%Type;
501: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE;

Line 498: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;

494: FROM OKC_K_HEADERS_B
495: WHERE ID = p_chr_id;
496:
497: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
498: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
499: l_khr_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
500: l_khr_currency OKC_K_HEADERS_B.CURRENCY_CODE%Type;
501: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE;
502:

Line 499: l_khr_end_date OKC_K_HEADERS_B.END_DATE%TYPE;

495: WHERE ID = p_chr_id;
496:
497: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
498: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
499: l_khr_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
500: l_khr_currency OKC_K_HEADERS_B.CURRENCY_CODE%Type;
501: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE;
502:
503: --cursor to get contract line status

Line 500: l_khr_currency OKC_K_HEADERS_B.CURRENCY_CODE%Type;

496:
497: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
498: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
499: l_khr_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
500: l_khr_currency OKC_K_HEADERS_B.CURRENCY_CODE%Type;
501: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE;
502:
503: --cursor to get contract line status
504: CURSOR kle_sts_csr (p_chr_id IN NUMBER) is

Line 501: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE;

497: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
498: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
499: l_khr_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
500: l_khr_currency OKC_K_HEADERS_B.CURRENCY_CODE%Type;
501: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE;
502:
503: --cursor to get contract line status
504: CURSOR kle_sts_csr (p_chr_id IN NUMBER) is
505: SELECT STS_CODE,

Line 835: FROM OKC_K_HEADERS_B

831: START_DATE,
832: END_DATE,
833: CURRENCY_CODE,
834: SCS_CODE
835: FROM OKC_K_HEADERS_B
836: WHERE ID = p_chr_id;
837:
838: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
839: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;

Line 838: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;

834: SCS_CODE
835: FROM OKC_K_HEADERS_B
836: WHERE ID = p_chr_id;
837:
838: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
839: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
840: l_khr_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
841: l_khr_currency OKC_K_HEADERS_B.CURRENCY_CODE%Type;
842: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE;

Line 839: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;

835: FROM OKC_K_HEADERS_B
836: WHERE ID = p_chr_id;
837:
838: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
839: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
840: l_khr_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
841: l_khr_currency OKC_K_HEADERS_B.CURRENCY_CODE%Type;
842: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE;
843:

Line 840: l_khr_end_date OKC_K_HEADERS_B.END_DATE%TYPE;

836: WHERE ID = p_chr_id;
837:
838: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
839: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
840: l_khr_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
841: l_khr_currency OKC_K_HEADERS_B.CURRENCY_CODE%Type;
842: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE;
843:
844: --cursor to get contract line status

Line 841: l_khr_currency OKC_K_HEADERS_B.CURRENCY_CODE%Type;

837:
838: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
839: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
840: l_khr_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
841: l_khr_currency OKC_K_HEADERS_B.CURRENCY_CODE%Type;
842: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE;
843:
844: --cursor to get contract line status
845: CURSOR kle_sts_csr (p_chr_id IN NUMBER) is

Line 842: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE;

838: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
839: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
840: l_khr_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
841: l_khr_currency OKC_K_HEADERS_B.CURRENCY_CODE%Type;
842: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE;
843:
844: --cursor to get contract line status
845: CURSOR kle_sts_csr (p_chr_id IN NUMBER) is
846: SELECT A.STS_CODE,

Line 1054: FROM OKC_K_HEADERS_B

1050: CURRENCY_CODE,
1051: SCS_CODE,
1052: CONTRACT_NUMBER,
1053: TEMPLATE_YN --Bug#4728470
1054: FROM OKC_K_HEADERS_B
1055: WHERE ID = p_chr_id;
1056:
1057: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
1058: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;

Line 1057: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;

1053: TEMPLATE_YN --Bug#4728470
1054: FROM OKC_K_HEADERS_B
1055: WHERE ID = p_chr_id;
1056:
1057: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
1058: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
1059: l_khr_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
1060: l_khr_currency OKC_K_HEADERS_B.CURRENCY_CODE%Type;
1061: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%Type;

Line 1058: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;

1054: FROM OKC_K_HEADERS_B
1055: WHERE ID = p_chr_id;
1056:
1057: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
1058: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
1059: l_khr_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
1060: l_khr_currency OKC_K_HEADERS_B.CURRENCY_CODE%Type;
1061: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%Type;
1062: l_khr_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

Line 1059: l_khr_end_date OKC_K_HEADERS_B.END_DATE%TYPE;

1055: WHERE ID = p_chr_id;
1056:
1057: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
1058: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
1059: l_khr_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
1060: l_khr_currency OKC_K_HEADERS_B.CURRENCY_CODE%Type;
1061: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%Type;
1062: l_khr_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
1063:

Line 1060: l_khr_currency OKC_K_HEADERS_B.CURRENCY_CODE%Type;

1056:
1057: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
1058: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
1059: l_khr_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
1060: l_khr_currency OKC_K_HEADERS_B.CURRENCY_CODE%Type;
1061: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%Type;
1062: l_khr_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
1063:
1064: --Bug#4728470

Line 1061: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%Type;

1057: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
1058: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
1059: l_khr_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
1060: l_khr_currency OKC_K_HEADERS_B.CURRENCY_CODE%Type;
1061: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%Type;
1062: l_khr_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
1063:
1064: --Bug#4728470
1065: l_khr_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

Line 1062: l_khr_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

1058: l_khr_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
1059: l_khr_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
1060: l_khr_currency OKC_K_HEADERS_B.CURRENCY_CODE%Type;
1061: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%Type;
1062: l_khr_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
1063:
1064: --Bug#4728470
1065: l_khr_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
1066:

Line 1065: l_khr_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

1061: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%Type;
1062: l_khr_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
1063:
1064: --Bug#4728470
1065: l_khr_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
1066:
1067: --cusrsor to get OKC_STATUS check if status not in OKC frozen statuses
1068: CURSOR okc_sts_csr (p_okl_sts IN VARCHAR2) IS
1069: SELECT ste_code