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 1196: FROM okc_k_headers_all_b

1192: l_invalid VARCHAR2(1) := 'N';
1193:
1194: CURSOR c_conv_date IS
1195: SELECT 'Y'
1196: FROM okc_k_headers_all_b
1197: WHERE id = p_chr_id
1198: AND conversion_type IS NOT NULL
1199: AND conversion_rate_date NOT BETWEEN start_date AND end_date;
1200:

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

1306: ***/
1307:
1308: l_api_name CONSTANT VARCHAR2(30) := 'check_covlvl_Overlap';
1309:
1310: TYPE chr120_tbl_type IS TABLE OF okc_k_headers_all_b.contract_number%TYPE INDEX BY BINARY_INTEGER;
1311: TYPE chr640_tbl_type IS TABLE OF VARCHAR2(640) INDEX BY BINARY_INTEGER;
1312: TYPE num_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1313:
1314: CURSOR c_chk_overlap(cp_chr_id IN NUMBER, cp_date IN DATE) IS

Line 1319: FROM okc_k_headers_all_b trgh,

1315: SELECT trgh.contract_number, nvl(trgh.contract_number_modifier, OKC_API.G_MISS_CHAR),
1316: nvl(rtrim(trgtl.line_number) || '.' || RTRIM(trgsl.line_number) ||', '|| RTRIM(trgst.name) ||' '|| RTRIM(trgsl.name), OKC_API.G_MISS_CHAR) trg_name,
1317: nvl(rtrim(srctl.line_number) || '.' || RTRIM(srcsl.line_number) ||', '|| RTRIM(srcst.name) ||' '|| RTRIM(srcsl.name), OKC_API.G_MISS_CHAR) src_name,
1318: srcsl.id srcsl_id
1319: FROM okc_k_headers_all_b trgh,
1320: okc_k_lines_v trgsl,
1321: okc_k_items trgi,
1322: okc_k_lines_b trgtl,
1323: okc_line_styles_v trgst,

Line 1740: FROM okc_k_headers_all_b

1736:
1737:
1738: CURSOR l_org_csr IS
1739: SELECT org_id --from R12, we use org_id instead of authoring_org_id
1740: FROM okc_k_headers_all_b
1741: WHERE id = p_chr_id;
1742:
1743:
1744: CURSOR l_salesperson_contact IS

Line 1748: ,okc_k_headers_all_b header

1744: CURSOR l_salesperson_contact IS
1745: SELECT contact.object1_id1
1746: FROM okc_contacts contact
1747: ,okc_k_party_roles_b party
1748: ,okc_k_headers_all_b header
1749: WHERE contact.cpl_id = party.id
1750: AND party.chr_id = p_chr_id
1751: AND party.jtot_object1_code = 'OKX_OPERUNIT' --'okx_party'
1752: --npalepu modified on 06-FEB-2007 for bug # 5855434

Line 2153: FROM okc_k_headers_all_b

2149: WHERE id = p_chr_id;
2150:
2151: CURSOR l_qa_csr IS
2152: SELECT contract_number, QCL_ID, scs_code
2153: FROM okc_k_headers_all_b
2154: WHERE id = p_chr_id;
2155:
2156: -- Object1_id1 in PRE rule
2157: CURSOR l_price_csr IS

Line 2159: FROM okc_k_headers_all_b

2155:
2156: -- Object1_id1 in PRE rule
2157: CURSOR l_price_csr IS
2158: SELECT price_list_id -- Object1_id1
2159: FROM okc_k_headers_all_b
2160: WHERE id = p_chr_id;
2161:
2162:
2163: CURSOR l_k_grp_csr IS

Line 2253: FROM okc_k_headers_all_b

2249:
2250: --start changes for org id in is_service_available
2251: CURSOR get_auth_org_csr IS
2252: SELECT authoring_org_id
2253: FROM okc_k_headers_all_b
2254: WHERE id = p_chr_id;
2255:
2256: get_auth_org_rec get_auth_org_csr%ROWTYPE;
2257: --End changes for org id in is_service_available

Line 3031: okc_k_headers_all_b OKC,

3027: cust_acct_id,
3028: start_date,
3029: end_date
3030: FROM
3031: okc_k_headers_all_b OKC,
3032: OKS_K_HEADERS_B OKS
3033: WHERE
3034: OKC.id = p_chr_id AND
3035: OKC.ID = OKS.chr_id

Line 3770: okc_k_headers_all_b rl

3766: SELECT prt.party_name
3767: FROM oe_hold_sources_all ohs,
3768: HZ_PARTIES prt,
3769: HZ_PARTY_SITES PS, HZ_CUST_ACCT_SITES_ALL CA, HZ_CUST_SITE_USES_ALL CS,
3770: okc_k_headers_all_b rl
3771: WHERE ohs.hold_entity_code = 'C'
3772: AND ohs.released_flag = 'N'
3773: AND ohs.org_id = okc_context.get_okc_org_id
3774: AND PS.PARTY_SITE_ID = CA.PARTY_SITE_ID

Line 3802: okc_k_headers_all_b rl

3798: HZ_PARTIES prt,
3799: HZ_PARTY_SITES PS,
3800: HZ_CUST_ACCT_SITES_ALL CA,
3801: HZ_CUST_SITE_USES_ALL CS,
3802: okc_k_headers_all_b rl
3803: WHERE ohs.hold_entity_code = 'C'
3804: AND ohs.released_flag = 'N'
3805: AND ohs.org_id = okc_context.get_okc_org_id
3806: AND ohs.hold_id = ohd.hold_id

Line 3834: okc_k_headers_all_b rl

3830: HZ_PARTIES prt,
3831: HZ_PARTY_SITES PS,
3832: HZ_CUST_ACCT_SITES_ALL CA,
3833: HZ_CUST_SITE_USES_ALL CS,
3834: okc_k_headers_all_b rl
3835: WHERE ohs.hold_entity_code = 'B'
3836: AND ohs.released_flag = 'N'
3837: AND ohs.org_id = okc_context.get_okc_org_id
3838: AND ohs.hold_id = ohd.hold_id

Line 4028: FROM okc_k_headers_all_b rl,

4024: -- GCHADHA --
4025: -- 4132844 --
4026: CURSOR check_address_header(l_site_use_id IN NUMBER, l_site_use_code IN VARCHAR2) IS
4027: SELECT CS.SITE_USE_ID, CS.STATUS, CS.CUST_ACCT_SITE_ID
4028: FROM okc_k_headers_all_b rl,
4029: HZ_CUST_SITE_USES_ALL CS
4030: WHERE rl.id = p_chr_id
4031: AND CS.SITE_USE_ID = l_site_use_id
4032: AND CS.SITE_USE_CODE = l_site_use_code;

Line 4039: FROM okc_k_headers_all_b

4035: l_sto_address_rec check_address_header%ROWTYPE;
4036:
4037: CURSOR get_billto_shipto(p_chr_id IN NUMBER) IS
4038: SELECT bill_to_site_use_id, ship_to_site_use_id
4039: FROM okc_k_headers_all_b
4040: WHERE id = p_chr_id ;
4041:
4042: l_bill_to_site_use_id NUMBER;
4043: l_ship_to_site_use_id NUMBER;

Line 4448: FROM okc_k_headers_all_b

4444: --commented out asked by umesh And org_id = p_org_id;
4445:
4446: CURSOR l_org_csr IS
4447: SELECT authoring_org_id, inv_organization_id
4448: FROM okc_k_headers_all_b
4449: WHERE id = p_chr_id;
4450:
4451: -- Changed this cursor because object1_id1 will be holding the party_site_id
4452: -- not the customer site use id.

Line 4461: FROM okc_k_headers_all_b

4457:
4458: --Changed cursor because ste_code does not have QA_HOLD
4459: CURSOR l_hdr_csr(l_chr_id NUMBER) IS
4460: SELECT sts_code --sts.ste_code sts_code
4461: FROM okc_k_headers_all_b
4462: -- ,okc_statuses_b sts
4463: WHERE id = l_chr_id;
4464: --And sts.code = chr.sts_code;
4465:

Line 4908: okc_k_headers_all_b c

4904: NVL(c.org_id, c.authoring_org_id) org_id,
4905: c.currency_code,
4906: c.bill_to_site_use_id
4907: FROM oks_k_headers_b s,
4908: okc_k_headers_all_b c
4909: WHERE s.chr_id = c.id
4910: AND c.id = p_chr_id;
4911:
4912: l_oks_header_rec oks_hdr_csr%ROWTYPE;

Line 5523: FROM okc_k_headers_all_b k_hdr

5519: --l_lvl_tbl Level_Element_Tbl;
5520:
5521: CURSOR get_currency_csr (p_chr_id NUMBER) IS
5522: SELECT k_hdr.currency_code
5523: FROM okc_k_headers_all_b k_hdr
5524: WHERE k_hdr.id = p_chr_id ;
5525:
5526: l_currency VARCHAR2(15);
5527:

Line 6299: FROM okc_k_headers_all_b

6295:
6296: --start changes for org id in is_service_available
6297: CURSOR get_auth_org_csr IS
6298: SELECT authoring_org_id
6299: FROM okc_k_headers_all_b
6300: WHERE id = p_chr_id;
6301:
6302: get_auth_org_rec get_auth_org_csr%ROWTYPE;
6303: --End changes for org id in is_service_available

Line 6564: FROM okc_k_headers_all_b

6560: AND chr_id = p_chr_id;
6561:
6562: CURSOR get_org_id IS
6563: SELECT AUTHORING_ORG_ID
6564: FROM okc_k_headers_all_b
6565: WHERE id = p_chr_id;
6566:
6567: CURSOR get_contr_cust IS
6568: SELECT object1_id1 party_id

Line 6745: FROM okc_k_headers_all_b

6741: -- Active or not
6742:
6743: CURSOR get_billto_shipto(p_chr_id IN NUMBER) IS
6744: SELECT bill_to_site_use_id, ship_to_site_use_id
6745: FROM okc_k_headers_all_b
6746: WHERE id = p_chr_id ;
6747:
6748:
6749: CURSOR get_billto_cust_acct(p_bill_to_site_use_id IN NUMBER) IS

Line 6820: FROM okc_k_headers_all_b

6816: AND CA.STATUS = 'A';
6817:
6818: CURSOR get_org_id IS
6819: SELECT AUTHORING_ORG_ID
6820: FROM okc_k_headers_all_b
6821: WHERE id = p_chr_id;
6822:
6823:
6824: l_bill_to_site_use_id NUMBER;

Line 7262: FROM okc_k_headers_all_b a, oks_subscr_header_b b

7258:
7259: -- is item instance valid
7260: CURSOR get_subscr(instId NUMBER) IS
7261: SELECT b.dnz_chr_id subscr_chr_id, b.cle_id subscr_line_id
7262: FROM okc_k_headers_all_b a, oks_subscr_header_b b
7263: WHERE b.instance_id = instId AND b.dnz_chr_id = a.id AND
7264: (a.id = p_chr_id OR (a.id <> p_chr_id AND a.sts_code IN ('ACTIVE', 'SIGNED')) );
7265:
7266: -- See if the cp dates fall within the the subscription line start date, end date

Line 7733: FROM okc_k_headers_all_b

7729: IS
7730:
7731: CURSOR get_old_chr_id(l_chr_id NUMBER) IS
7732: SELECT orig_system_id1
7733: FROM okc_k_headers_all_b
7734: WHERE id = l_chr_id
7735: AND datetime_cancelled IS NULL; --Changes [llc]
7736:
7737: -- Gets old line id's that have a lock

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

7846: l_dummy_msg VARCHAR2(200);
7847:
7848: CURSOR cur_renewal_source_lines (p_chr_id NUMBER) IS
7849: SELECT 1
7850: FROM okc_operation_lines a, okc_operation_instances b, okc_class_operations c, okc_k_headers_all_b d, okc_statuses_b e
7851: WHERE a.subject_chr_id = p_chr_id
7852: AND c.id = b.cop_id
7853: AND c.opn_code IN('RENEWAL', 'REN_CON')
7854: AND a.oie_id = b.id

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

7930:
7931:
7932: CURSOR cur_is_K_renewed IS
7933: SELECT d.id target_contract_id
7934: FROM okc_operation_lines a, okc_operation_instances b, okc_class_operations c, okc_k_headers_all_b d, okc_statuses_b e
7935: WHERE a.object_chr_id = p_chr_id
7936: AND c.id = b.cop_id
7937: AND c.opn_code IN('RENEWAL', 'REN_CON')
7938: AND a.oie_id = b.id

Line 7981: FROM okc_k_headers_all_b

7977:
7978:
7979: CURSOR cur_target_contract_number (p_contract_id NUMBER) IS
7980: SELECT contract_number
7981: FROM okc_k_headers_all_b
7982: WHERE id = p_contract_id;
7983:
7984: CURSOR cur_target_line_number (p_cle_id NUMBER) IS
7985: SELECT line_number