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.OKS_QA_DATA_INTEGRITY dependencies on OKC_K_HEADERS_ALL_B

Line 89: FROM okc_k_headers_all_b WHERE id = p_chr_id;

85: l_contr_name VARCHAR2(3300);
86:
87: CURSOR get_contr_name(l_chr_id NUMBER) IS
88: SELECT contract_number, contract_number_modifier
89: FROM okc_k_headers_all_b WHERE id = p_chr_id;
90: l_contr_num VARCHAR2(120);
91: l_contr_modifier VARCHAR2(120);
92:
93: BEGIN

Line 288: FROM okc_k_headers_all_b

284: IS
285: -- Gets PO number at contract level.
286: CURSOR get_po IS
287: SELECT CUST_PO_NUMBER_REQ_YN, CUST_PO_NUMBER
288: FROM okc_k_headers_all_b
289: WHERE id = p_chr_id AND CUST_PO_NUMBER_REQ_YN = 'Y';
290:
291: l_po_flag VARCHAR2(3);
292: l_po_num VARCHAR2(150);

Line 432: FROM okc_k_headers_all_b

428: l_conversion_type VARCHAR2(30);
429:
430: CURSOR get_contract_info IS
431: SELECT currency_code, authoring_org_id
432: FROM okc_k_headers_all_b
433: WHERE id = p_chr_id;
434: -- CVN
435: CURSOR get_rule IS
436: SELECT CONVERSION_TYPE --object1_id1

Line 437: FROM okc_k_headers_all_b

433: WHERE id = p_chr_id;
434: -- CVN
435: CURSOR get_rule IS
436: SELECT CONVERSION_TYPE --object1_id1
437: FROM okc_k_headers_all_b
438: WHERE id = p_chr_id;
439:
440: BEGIN
441: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 501: FROM okc_k_headers_all_b WHERE id = p_chr_id;

497: IS
498:
499: CURSOR get_hdr_info(p_chr_id NUMBER) IS
500: SELECT currency_code, price_list_id, sts_code
501: FROM okc_k_headers_all_b WHERE id = p_chr_id;
502:
503: CURSOR get_status(l_sts_code VARCHAR) IS
504: SELECT ste_code
505: FROM okc_statuses_b

Line 719: FROM okc_k_headers_all_b

715: IS
716:
717: CURSOR ORG_CUR IS
718: SELECT authoring_org_id
719: FROM okc_k_headers_all_b
720: WHERE id = p_chr_id;
721:
722: CURSOR TAX_METHOD_CUR(p_org_id NUMBER) IS
723: SELECT tax_method_code

Line 1060: FROM okc_k_headers_all_b chdr,

1056: CURSOR l_chr_csr IS
1057: SELECT chdr.contract_number
1058: , cle.id
1059: , chdr.contract_number_modifier
1060: FROM okc_k_headers_all_b chdr,
1061: OKC_K_ITEMS cim,
1062: OKC_LINE_STYLES_V lse,
1063: OKC_K_LINES_B cle,
1064: OKC_STATUSES_B sts

Line 1247: TYPE chr120_tbl_type IS TABLE OF okc_k_headers_all_b.contract_number%TYPE INDEX BY BINARY_INTEGER;

1243: ***/
1244:
1245: l_api_name CONSTANT VARCHAR2(30) := 'check_covlvl_Overlap';
1246:
1247: TYPE chr120_tbl_type IS TABLE OF okc_k_headers_all_b.contract_number%TYPE INDEX BY BINARY_INTEGER;
1248: TYPE chr640_tbl_type IS TABLE OF VARCHAR2(640) INDEX BY BINARY_INTEGER;
1249: TYPE num_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1250:
1251: CURSOR c_chk_overlap(cp_chr_id IN NUMBER, cp_date IN DATE) IS

Line 1256: FROM okc_k_headers_all_b trgh,

1252: SELECT trgh.contract_number, nvl(trgh.contract_number_modifier, OKC_API.G_MISS_CHAR),
1253: nvl(rtrim(trgtl.line_number) || '.' || RTRIM(trgsl.line_number) ||', '|| RTRIM(trgst.name) ||' '|| RTRIM(trgsl.name), OKC_API.G_MISS_CHAR) trg_name,
1254: nvl(rtrim(srctl.line_number) || '.' || RTRIM(srcsl.line_number) ||', '|| RTRIM(srcst.name) ||' '|| RTRIM(srcsl.name), OKC_API.G_MISS_CHAR) src_name,
1255: srcsl.id srcsl_id
1256: FROM okc_k_headers_all_b trgh,
1257: okc_k_lines_v trgsl,
1258: okc_k_items trgi,
1259: okc_k_lines_b trgtl,
1260: okc_line_styles_v trgst,

Line 1671: FROM okc_k_headers_all_b

1667:
1668:
1669: CURSOR l_org_csr IS
1670: SELECT org_id --from R12, we use org_id instead of authoring_org_id
1671: FROM okc_k_headers_all_b
1672: WHERE id = p_chr_id;
1673:
1674:
1675: CURSOR l_salesperson_contact IS

Line 1679: ,okc_k_headers_all_b header

1675: CURSOR l_salesperson_contact IS
1676: SELECT contact.object1_id1
1677: FROM okc_contacts contact
1678: ,okc_k_party_roles_b party
1679: ,okc_k_headers_all_b header
1680: WHERE contact.cpl_id = party.id
1681: AND party.chr_id = p_chr_id
1682: AND party.jtot_object1_code = 'OKX_OPERUNIT' --'okx_party'
1683: --npalepu modified on 06-FEB-2007 for bug # 5855434

Line 2084: FROM okc_k_headers_all_b

2080: WHERE id = p_chr_id;
2081:
2082: CURSOR l_qa_csr IS
2083: SELECT contract_number, QCL_ID, scs_code
2084: FROM okc_k_headers_all_b
2085: WHERE id = p_chr_id;
2086:
2087: -- Object1_id1 in PRE rule
2088: CURSOR l_price_csr IS

Line 2090: FROM okc_k_headers_all_b

2086:
2087: -- Object1_id1 in PRE rule
2088: CURSOR l_price_csr IS
2089: SELECT price_list_id -- Object1_id1
2090: FROM okc_k_headers_all_b
2091: WHERE id = p_chr_id;
2092:
2093:
2094: CURSOR l_k_grp_csr IS

Line 2184: FROM okc_k_headers_all_b

2180:
2181: --start changes for org id in is_service_available
2182: CURSOR get_auth_org_csr IS
2183: SELECT authoring_org_id
2184: FROM okc_k_headers_all_b
2185: WHERE id = p_chr_id;
2186:
2187: get_auth_org_rec get_auth_org_csr%ROWTYPE;
2188: --End changes for org id in is_service_available

Line 2962: okc_k_headers_all_b OKC,

2958: cust_acct_id,
2959: start_date,
2960: end_date
2961: FROM
2962: okc_k_headers_all_b OKC,
2963: OKS_K_HEADERS_B OKS
2964: WHERE
2965: OKC.id = p_chr_id AND
2966: OKC.ID = OKS.chr_id

Line 3698: okc_k_headers_all_b rl

3694: SELECT prt.party_name
3695: FROM oe_hold_sources_all ohs,
3696: HZ_PARTIES prt,
3697: HZ_PARTY_SITES PS, HZ_CUST_ACCT_SITES_ALL CA, HZ_CUST_SITE_USES_ALL CS,
3698: okc_k_headers_all_b rl
3699: WHERE ohs.hold_entity_code = 'C'
3700: AND ohs.released_flag = 'N'
3701: AND ohs.org_id = okc_context.get_okc_org_id
3702: AND PS.PARTY_SITE_ID = CA.PARTY_SITE_ID

Line 3881: FROM okc_k_headers_all_b rl,

3877: -- GCHADHA --
3878: -- 4132844 --
3879: CURSOR check_address_header(l_site_use_id IN NUMBER, l_site_use_code IN VARCHAR2) IS
3880: SELECT CS.SITE_USE_ID, CS.STATUS, CS.CUST_ACCT_SITE_ID
3881: FROM okc_k_headers_all_b rl,
3882: HZ_CUST_SITE_USES_ALL CS
3883: WHERE rl.id = p_chr_id
3884: AND CS.SITE_USE_ID = l_site_use_id
3885: AND CS.SITE_USE_CODE = l_site_use_code;

Line 3892: FROM okc_k_headers_all_b

3888: l_sto_address_rec check_address_header%ROWTYPE;
3889:
3890: CURSOR get_billto_shipto(p_chr_id IN NUMBER) IS
3891: SELECT bill_to_site_use_id, ship_to_site_use_id
3892: FROM okc_k_headers_all_b
3893: WHERE id = p_chr_id ;
3894:
3895: l_bill_to_site_use_id NUMBER;
3896: l_ship_to_site_use_id NUMBER;

Line 4301: FROM okc_k_headers_all_b

4297: --commented out asked by umesh And org_id = p_org_id;
4298:
4299: CURSOR l_org_csr IS
4300: SELECT authoring_org_id, inv_organization_id
4301: FROM okc_k_headers_all_b
4302: WHERE id = p_chr_id;
4303:
4304: -- Changed this cursor because object1_id1 will be holding the party_site_id
4305: -- not the customer site use id.

Line 4314: FROM okc_k_headers_all_b

4310:
4311: --Changed cursor because ste_code does not have QA_HOLD
4312: CURSOR l_hdr_csr(l_chr_id NUMBER) IS
4313: SELECT sts_code --sts.ste_code sts_code
4314: FROM okc_k_headers_all_b
4315: -- ,okc_statuses_b sts
4316: WHERE id = l_chr_id;
4317: --And sts.code = chr.sts_code;
4318:

Line 4761: okc_k_headers_all_b c

4757: NVL(c.org_id, c.authoring_org_id) org_id,
4758: c.currency_code,
4759: c.bill_to_site_use_id
4760: FROM oks_k_headers_b s,
4761: okc_k_headers_all_b c
4762: WHERE s.chr_id = c.id
4763: AND c.id = p_chr_id;
4764:
4765: l_oks_header_rec oks_hdr_csr%ROWTYPE;

Line 5376: FROM okc_k_headers_all_b k_hdr

5372: --l_lvl_tbl Level_Element_Tbl;
5373:
5374: CURSOR get_currency_csr (p_chr_id NUMBER) IS
5375: SELECT k_hdr.currency_code
5376: FROM okc_k_headers_all_b k_hdr
5377: WHERE k_hdr.id = p_chr_id ;
5378:
5379: l_currency VARCHAR2(15);
5380:

Line 6152: FROM okc_k_headers_all_b

6148:
6149: --start changes for org id in is_service_available
6150: CURSOR get_auth_org_csr IS
6151: SELECT authoring_org_id
6152: FROM okc_k_headers_all_b
6153: WHERE id = p_chr_id;
6154:
6155: get_auth_org_rec get_auth_org_csr%ROWTYPE;
6156: --End changes for org id in is_service_available

Line 6417: FROM okc_k_headers_all_b

6413: AND chr_id = p_chr_id;
6414:
6415: CURSOR get_org_id IS
6416: SELECT AUTHORING_ORG_ID
6417: FROM okc_k_headers_all_b
6418: WHERE id = p_chr_id;
6419:
6420: CURSOR get_contr_cust IS
6421: SELECT object1_id1 party_id

Line 6598: FROM okc_k_headers_all_b

6594: -- Active or not
6595:
6596: CURSOR get_billto_shipto(p_chr_id IN NUMBER) IS
6597: SELECT bill_to_site_use_id, ship_to_site_use_id
6598: FROM okc_k_headers_all_b
6599: WHERE id = p_chr_id ;
6600:
6601:
6602: CURSOR get_billto_cust_acct(p_bill_to_site_use_id IN NUMBER) IS

Line 6671: FROM okc_k_headers_all_b

6667: AND CA.STATUS = 'A';
6668:
6669: CURSOR get_org_id IS
6670: SELECT AUTHORING_ORG_ID
6671: FROM okc_k_headers_all_b
6672: WHERE id = p_chr_id;
6673:
6674:
6675: l_bill_to_site_use_id NUMBER;

Line 7113: FROM okc_k_headers_all_b a, oks_subscr_header_b b

7109:
7110: -- is item instance valid
7111: CURSOR get_subscr(instId NUMBER) IS
7112: SELECT b.dnz_chr_id subscr_chr_id, b.cle_id subscr_line_id
7113: FROM okc_k_headers_all_b a, oks_subscr_header_b b
7114: WHERE b.instance_id = instId AND b.dnz_chr_id = a.id AND
7115: (a.id = p_chr_id OR (a.id <> p_chr_id AND a.sts_code IN ('ACTIVE', 'SIGNED')) );
7116:
7117: -- See if the cp dates fall within the the subscription line start date, end date

Line 7584: FROM okc_k_headers_all_b

7580: IS
7581:
7582: CURSOR get_old_chr_id(l_chr_id NUMBER) IS
7583: SELECT orig_system_id1
7584: FROM okc_k_headers_all_b
7585: WHERE id = l_chr_id
7586: AND datetime_cancelled IS NULL; --Changes [llc]
7587:
7588: -- Gets old line id's that have a lock

Line 7701: FROM okc_operation_lines a, okc_operation_instances b, okc_class_operations c, okc_k_headers_all_b d, okc_statuses_b e

7697: l_dummy_msg VARCHAR2(200);
7698:
7699: CURSOR cur_renewal_source_lines (p_chr_id NUMBER) IS
7700: SELECT 1
7701: FROM okc_operation_lines a, okc_operation_instances b, okc_class_operations c, okc_k_headers_all_b d, okc_statuses_b e
7702: WHERE a.subject_chr_id = p_chr_id
7703: AND c.id = b.cop_id
7704: AND c.opn_code IN('RENEWAL', 'REN_CON')
7705: AND a.oie_id = b.id

Line 7785: FROM okc_operation_lines a, okc_operation_instances b, okc_class_operations c, okc_k_headers_all_b d, okc_statuses_b e

7781:
7782:
7783: CURSOR cur_is_K_renewed IS
7784: SELECT d.id target_contract_id
7785: FROM okc_operation_lines a, okc_operation_instances b, okc_class_operations c, okc_k_headers_all_b d, okc_statuses_b e
7786: WHERE a.object_chr_id = p_chr_id
7787: AND c.id = b.cop_id
7788: AND c.opn_code IN('RENEWAL', 'REN_CON')
7789: AND a.oie_id = b.id

Line 7832: FROM okc_k_headers_all_b

7828:
7829:
7830: CURSOR cur_target_contract_number (p_contract_id NUMBER) IS
7831: SELECT contract_number
7832: FROM okc_k_headers_all_b
7833: WHERE id = p_contract_id;
7834:
7835: CURSOR cur_target_line_number (p_cle_id NUMBER) IS
7836: SELECT line_number