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_ACTIVATE_IB_PVT dependencies on OKC_K_HEADERS_B

Line 829: OKC_K_HEADERS_B CHR

825: --cursor to fetch ib master org id
826: CURSOR mstr_org_csr (p_chr_id IN NUMBER) is
827: SELECT MP.master_organization_id
828: FROM MTL_PARAMETERS MP,
829: OKC_K_HEADERS_B CHR
830: WHERE MP.organization_id = CHR.inv_organization_id
831: AND CHR.id = p_chr_id;
832:
833: l_inv_mstr_org_id NUMBER;

Line 890: FROM OKC_K_HEADERS_B chrb

886: l_party_account NUMBER;
887: ------------------------------------11.5.10:Rule Migration----*/
888: CURSOR party_account_csr(p_chrv_id IN NUMBER) is
889: SELECT chrb.cust_acct_id
890: FROM OKC_K_HEADERS_B chrb
891: WHERE chrb.id = p_chrv_id;
892:
893: l_party_account NUMBER;
894:

Line 1534: FROM okc_k_headers_b CHR

1530: AND CIX.INSTANCE_ID = CSI.INSTANCE_ID);
1531:
1532: CURSOR c_check_usage(p_contract_id IN NUMBER) IS
1533: SELECT '!'
1534: FROM okc_k_headers_b CHR
1535: WHERE chr.id = p_contract_id
1536: AND EXISTS (SELECT '1'
1537: FROM okc_line_styles_b lse,
1538: okc_k_lines_b cle

Line 1939: From OKC_K_HEADERS_B

1935: SELECT SCS_CODE,
1936: STS_CODE,
1937: INV_ORGANIZATION_ID,
1938: START_DATE -- rkuttiya added for bug # 6795295
1939: From OKC_K_HEADERS_B
1940: WHERE ID = P_CHRV_ID;
1941:
1942: l_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE;
1943: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;

Line 1942: l_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE;

1938: START_DATE -- rkuttiya added for bug # 6795295
1939: From OKC_K_HEADERS_B
1940: WHERE ID = P_CHRV_ID;
1941:
1942: l_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE;
1943: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
1944: l_inv_org_id OKC_K_HEADERS_B.INV_ORGANIZATION_ID%TYPE;
1945:
1946: --cursor to get ib line

Line 1943: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;

1939: From OKC_K_HEADERS_B
1940: WHERE ID = P_CHRV_ID;
1941:
1942: l_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE;
1943: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
1944: l_inv_org_id OKC_K_HEADERS_B.INV_ORGANIZATION_ID%TYPE;
1945:
1946: --cursor to get ib line
1947: Cursor ib_line_csr(p_chrv_id IN Number) is

Line 1944: l_inv_org_id OKC_K_HEADERS_B.INV_ORGANIZATION_ID%TYPE;

1940: WHERE ID = P_CHRV_ID;
1941:
1942: l_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE;
1943: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
1944: l_inv_org_id OKC_K_HEADERS_B.INV_ORGANIZATION_ID%TYPE;
1945:
1946: --cursor to get ib line
1947: Cursor ib_line_csr(p_chrv_id IN Number) is
1948: SELECT cle.id,

Line 1962: OKC_K_HEADERS_B CHR

1958: --cursor to fetch ib master org id
1959: CURSOR mstr_org_csr (p_chr_id IN NUMBER) is
1960: SELECT MP.master_organization_id
1961: FROM MTL_PARAMETERS MP,
1962: OKC_K_HEADERS_B CHR
1963: WHERE MP.organization_id = CHR.inv_organization_id
1964: AND CHR.id = p_chr_id;
1965:
1966: CURSOR party_account_csr(p_chrv_id IN NUMBER) is

Line 1968: FROM OKC_K_HEADERS_B chrb

1964: AND CHR.id = p_chr_id;
1965:
1966: CURSOR party_account_csr(p_chrv_id IN NUMBER) is
1967: SELECT chrb.cust_acct_id
1968: FROM OKC_K_HEADERS_B chrb
1969: WHERE chrb.id = p_chrv_id;
1970:
1971:
1972: l_inv_mstr_org_id NUMBER;

Line 2424: OKC_K_HEADERS_B chr

2420: chr.scs_code
2421: FROM OKC_K_PARTY_ROLES_B cplb,
2422: OKC_RULES_B rul,
2423: OKL_K_HEADERS khr,
2424: OKC_K_HEADERS_B chr
2425: WHERE cplb.chr_id = chr.id
2426: AND cplb.dnz_chr_id = chr.id
2427: AND cplb.rle_code = 'LESSEE'
2428: AND rul.dnz_chr_id = chr.id

Line 2821: okc_k_headers_b chrb

2817: CURSOR srl_ctrl_csr (p_inv_item_id IN NUMBER,
2818: p_chr_id IN NUMBER) IS
2819: SELECT mtl.serial_number_control_code
2820: FROM mtl_system_items mtl,
2821: okc_k_headers_b chrb
2822: WHERE mtl.inventory_item_id = p_inv_item_id
2823: AND mtl.organization_id = chrb.inv_organization_id
2824: --BUG# 3489089
2825: AND chrb.id = p_chr_id;

Line 2832: okc_k_headers_b chrb,

2828: CURSOR srl_ctrl_csr2 (p_inv_item_id IN NUMBER,
2829: p_cle_id IN NUMBER) IS
2830: SELECT mtl.serial_number_control_code
2831: FROM mtl_system_items mtl,
2832: okc_k_headers_b chrb,
2833: okc_k_lines_b cleb
2834: WHERE mtl.inventory_item_id = p_inv_item_id
2835: AND mtl.organization_id = chrb.inv_organization_id
2836: AND chrb.id = cleb.dnz_chr_id

Line 2948: from okc_k_headers_b chr,

2944: cursor get_orig_k_id (p_chr_id in number,
2945: p_fin_ast_cle_id in number) is
2946: select chr.ORIG_SYSTEM_ID1 orig_chr_id,
2947: cle.orig_system_id1 orig_fin_ast_cle_id
2948: from okc_k_headers_b chr,
2949: okc_k_lines_b cle
2950: where chr.id = p_chr_id
2951: and cle.id = p_fin_ast_cle_id
2952: and cle.chr_id = p_chr_id

Line 3122: l_orig_k_id okc_k_headers_b.id%type;

3118: l_orig_serialized VARCHAR2(1) DEFAULT OKL_API.G_FALSE;
3119: l_rbk_serialized VARCHAR2(1) DEFAULT OKL_API.G_FALSE;
3120: -- gboomina Bug 5362977 - End
3121:
3122: l_orig_k_id okc_k_headers_b.id%type;
3123: l_orig_fin_ast_cle_id okc_k_lines_b.id%type;
3124: l_instance_id okc_k_items.id%type;
3125: l_instance_cle_id okc_k_items.cle_id%type;
3126: