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

Line 241: From OKC_K_HEADERS_B Hdr;

237: max(hdr.id) maxid,
238: avg(hdr.id) avgid,
239: stddev(hdr.id) stdid,
240: count(*) total
241: From OKC_K_HEADERS_B Hdr;
242:
243: Cursor l_hdr_agg_csr3 IS
244: Select /*+ PARALLEL(rgp) */
245: min(rgp.id) minid,

Line 259: From OKC_K_HEADERS_BH Hdr;

255: max(hdr.id) maxid,
256: avg(hdr.id) avgid,
257: stddev(hdr.id) stdid,
258: count(*) total
259: From OKC_K_HEADERS_BH Hdr;
260:
261: l_hdr_agg_rec l_hdr_agg_csr1%ROWTYPE;
262:
263: -----------------------------------------------------------------

Line 441: -- The following csr is on OKC_K_HEADERS_B

437:
438: FND_FILE.PUT_LINE (FND_FILE.LOG, 'l_sub_requests = '|| l_sub_requests );
439:
440: Else
441: -- The following csr is on OKC_K_HEADERS_B
442: open l_hdr_agg_csr2;
443: fetch l_hdr_agg_csr2 into l_hdr_agg_rec;
444: close l_hdr_agg_csr2;
445:

Line 528: -- The following csr is on OKC_K_HEADERS_BH

524: l_hdr_agg_rec.total,
525: nvl(ip_sub_requests,30));
526: FND_FILE.PUT_LINE (FND_FILE.LOG, 'l_sub_requests = '|| l_sub_requests );
527: Else
528: -- The following csr is on OKC_K_HEADERS_BH
529: open l_hdr_agg_csr4;
530: fetch l_hdr_agg_csr4 into l_hdr_agg_rec;
531: close l_hdr_agg_csr4;
532:

Line 617: -- The following csr is on OKC_K_HEADERS_B

613: l_hdr_agg_rec.total,
614: nvl(ip_sub_requests,30));
615: FND_FILE.PUT_LINE (FND_FILE.LOG, 'l_sub_requests = '|| l_sub_requests );
616: Else
617: -- The following csr is on OKC_K_HEADERS_B
618: open l_hdr_agg_csr2;
619: fetch l_hdr_agg_csr2 into l_hdr_agg_rec;
620: close l_hdr_agg_csr2;
621:

Line 702: -- The following csr is on OKC_K_HEADERS_B

698: l_hdr_agg_rec.total,
699: nvl(ip_sub_requests,30));
700: FND_FILE.PUT_LINE (FND_FILE.LOG, 'l_sub_requests = '|| l_sub_requests );
701: Else
702: -- The following csr is on OKC_K_HEADERS_B
703: open l_hdr_agg_csr4;
704: fetch l_hdr_agg_csr4 into l_hdr_agg_rec;
705: close l_hdr_agg_csr4;
706:

Line 781: -- The following csr is on OKC_K_HEADERS_BH

777: FND_FILE.PUT_LINE (FND_FILE.LOG, 'l_hdr_agg_re.maxid = '|| l_hdr_agg_rec.maxid );
778: FND_FILE.PUT_LINE (FND_FILE.LOG, 'l_hdr_agg_re.total = '|| l_hdr_agg_rec.total );
779:
780: Else
781: -- The following csr is on OKC_K_HEADERS_BH
782: open l_hdr_agg_csr4;
783: fetch l_hdr_agg_csr4 into l_hdr_agg_rec;
784: close l_hdr_agg_csr4;
785:

Line 838: -- The following csr is on OKC_K_HEADERS_B

834: l_hdr_agg_rec.total,
835: nvl(ip_sub_requests-1,30));
836: FND_FILE.PUT_LINE (FND_FILE.LOG, 'l_sub_requests = '|| l_sub_requests );
837: Else
838: -- The following csr is on OKC_K_HEADERS_B
839: open l_hdr_agg_csr2;
840: fetch l_hdr_agg_csr2 into l_hdr_agg_rec;
841: close l_hdr_agg_csr2;
842:

Line 1537: , OKC_K_HEADERS_B HDR

1533: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)))
1534: PRICE_LIST_ID --OKC
1535: FROM OKC_RULE_GROUPS_B RGP
1536: , OKC_RULES_B RUL
1537: , OKC_K_HEADERS_B HDR
1538: WHERE rgp.id = rul.rgp_id
1539: and rgp.cle_id is null
1540: and rgp.chr_id is not null
1541: and rgp.rgd_code = 'SVC_K'

Line 2022: , OKC_K_HEADERS_B HDR

2018: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)))
2019: PRICE_LIST_ID --OKC
2020: FROM OKC_RULE_GROUPS_B RGP
2021: , OKC_RULES_B RUL
2022: , OKC_K_HEADERS_B HDR
2023: WHERE rgp.id = rul.rgp_id
2024: and rgp.cle_id is null
2025: and rgp.chr_id is not null
2026: and rgp.rgd_code = 'SVC_K'

Line 2084: FROM OKC_K_HEADERS_B HDR

2080: SELECT HDR.CONTRACT_NUMBER
2081: , HDR.CONTRACT_NUMBER_MODIFIER
2082: , RUL.ID
2083: , RGP.ID RGP_ID
2084: FROM OKC_K_HEADERS_B HDR
2085: , OKC_RULE_GROUPS_B RGP
2086: , OKC_RULES_B RUL
2087: WHERE HDR.ID = P_HDR_ID
2088: AND RGP.DNZ_CHR_ID = P_HDR_ID

Line 3865: , OKC_K_HEADERS_B HDR

3861: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)))
3862: LEVEL_AMOUNT
3863: FROM OKC_RULE_GROUPS_B RGP
3864: , OKC_RULES_B RUL
3865: , OKC_K_HEADERS_B HDR
3866: WHERE RGP.ID = RUL.RGP_ID
3867: AND RUL.RULE_INFORMATION_CATEGORY IN ('DST','ARL','CCR','GPR','IRT','TAX','IBR','PDL','QRE','SLH','CAN','BTO','IRE','LRT','STO','PTR',
3868: 'ECE','PMP','DST','RCN','RSN','LMT','PRE','SLL')
3869: AND RGP.CLE_ID IS NOT NULL

Line 4338: , OKC_K_HEADERS_B HDR

4334: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)))
4335: LEVEL_AMOUNT
4336: FROM OKC_RULE_GROUPS_B RGP
4337: , OKC_RULES_B RUL
4338: , OKC_K_HEADERS_B HDR
4339: WHERE RGP.ID = RUL.RGP_ID
4340: AND RUL.RULE_INFORMATION_CATEGORY IN ('DST','ARL','CCR','GPR','IRT','TAX','IBR','PDL','QRE','SLH','CAN','BTO','IRE','LRT','STO','PTR',
4341: 'ECE','PMP','DST','RCN','RSN','LMT','PRE','SLL')
4342: AND RGP.CLE_ID IS NOT NULL

Line 4399: FROM OKC_K_HEADERS_B HDR

4395: , HDR.CONTRACT_NUMBER_MODIFIER
4396: , LIN.LINE_NUMBER
4397: , RUL.ID
4398: , RGP.ID RGP_ID
4399: FROM OKC_K_HEADERS_B HDR
4400: , OKC_RULE_GROUPS_B RGP
4401: , OKC_RULES_B RUL
4402: , OKC_K_LINES_B LIN
4403: WHERE HDR.ID = P_HDR_ID

Line 6311: , OKC_K_HEADERS_BH HDR

6307: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)))
6308: LEVEL_AMOUNT
6309: FROM OKC_RULE_GROUPS_BH RGP
6310: , OKC_RULES_BH RUL
6311: , OKC_K_HEADERS_BH HDR
6312: WHERE RGP.ID = RUL.RGP_ID
6313: AND RUL.RULE_INFORMATION_CATEGORY IN ('DST','ARL','CCR','GPR','IRT','TAX','IBR','PDL','QRE','SLH','CAN','BTO','IRE','LRT','STO','PTR',
6314: 'ECE','PMP','DST','RCN','RSN','LMT','PRE','SLL')
6315: AND RGP.CLE_ID IS NOT NULL

Line 6787: , OKC_K_HEADERS_BH HDR

6783: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)))
6784: LEVEL_AMOUNT
6785: FROM OKC_RULE_GROUPS_BH RGP
6786: , OKC_RULES_BH RUL
6787: , OKC_K_HEADERS_BH HDR
6788: WHERE RGP.ID = RUL.RGP_ID
6789: AND RUL.RULE_INFORMATION_CATEGORY IN ('DST','ARL','CCR','GPR','IRT','TAX','IBR','PDL','QRE','SLH','CAN','BTO','IRE','LRT','STO','PTR',
6790: 'ECE','PMP','DST','RCN','RSN','LMT','PRE','SLL')
6791: AND RGP.CLE_ID IS NOT NULL

Line 6852: FROM OKC_K_HEADERS_BH HDR

6848: , LIN.MAJOR_VERSION
6849: , LIN.LINE_NUMBER
6850: , RUL.ID
6851: , RGP.ID RGP_ID
6852: FROM OKC_K_HEADERS_BH HDR
6853: , OKC_RULE_GROUPS_BH RGP
6854: , OKC_RULES_BH RUL
6855: , OKC_K_LINES_BH LIN
6856: WHERE HDR.ID = P_HDR_ID

Line 8779: , OKC_K_HEADERS_BH HDR

8775: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)))
8776: PRICE_LIST_ID --OKC
8777: FROM OKC_RULE_GROUPS_BH RGP
8778: , OKC_RULES_BH RUL
8779: , OKC_K_HEADERS_BH HDR
8780: WHERE rgp.id = rul.rgp_id
8781: and rgp.cle_id is null
8782: and rgp.chr_id is not null
8783: and rgp.rgd_code = 'SVC_K'

Line 9260: , OKC_K_HEADERS_BH HDR

9256: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)))
9257: PRICE_LIST_ID --OKC
9258: FROM OKC_RULE_GROUPS_BH RGP
9259: , OKC_RULES_BH RUL
9260: , OKC_K_HEADERS_BH HDR
9261: WHERE rgp.id = rul.rgp_id
9262: and rgp.cle_id is null
9263: and rgp.chr_id is not null
9264: and rgp.rgd_code = 'SVC_K'

Line 9322: FROM OKC_K_HEADERS_BH HDR

9318: , HDR.CONTRACT_NUMBER_MODIFIER
9319: , HDR.MAJOR_VERSION
9320: , RUL.ID
9321: , RGP.ID RGP_ID
9322: FROM OKC_K_HEADERS_BH HDR
9323: , OKC_RULE_GROUPS_BH RGP
9324: , OKC_RULES_BH RUL
9325: WHERE HDR.ID = P_HDR_ID
9326: AND RGP.DNZ_CHR_ID = P_HDR_ID

Line 11411: , OKC_K_HEADERS_B HDR

11407: LEVEL_AMOUNT
11408:
11409: FROM OKC_RULE_GROUPS_B RGP
11410: , OKC_RULES_B RUL
11411: , OKC_K_HEADERS_B HDR
11412: WHERE rgp.id = rul.rgp_id
11413: and rgp.rgd_code = 'SVC_K'
11414: AND RUL.RULE_INFORMATION_CATEGORY IN
11415: ('ARL','CCR','GPR','RVE','IRT','TAX','ERN','QTO', 'RPO', 'RPT','RER', 'RRU',

Line 12172: , OKC_K_HEADERS_B HDR

12168: LEVEL_AMOUNT
12169:
12170: FROM OKC_RULE_GROUPS_B RGP
12171: , OKC_RULES_B RUL
12172: , OKC_K_HEADERS_B HDR
12173: WHERE rgp.id = rul.rgp_id
12174: and rgp.rgd_code = 'SVC_K'
12175: AND RUL.RULE_INFORMATION_CATEGORY IN
12176: ('ARL','CCR','GPR','RVE','IRT','TAX','ERN','QTO', 'RPO', 'RPT','RER', 'RRU',

Line 12256: FROM OKC_K_HEADERS_B HDR

12252: SELECT HDR.CONTRACT_NUMBER
12253: , HDR.CONTRACT_NUMBER_MODIFIER
12254: , RUL.ID
12255: , RGP.ID RGP_ID
12256: FROM OKC_K_HEADERS_B HDR
12257: , OKC_RULE_GROUPS_B RGP
12258: , OKC_RULES_B RUL
12259: WHERE HDR.ID = P_HDR_ID
12260: AND RGP.DNZ_CHR_ID = P_HDR_ID

Line 12278: FROM OKC_K_HEADERS_B HDR

12274: , HDR.CONTRACT_NUMBER_MODIFIER
12275: , LIN.LINE_NUMBER
12276: , RUL.ID
12277: , RGP.ID RGP_ID
12278: FROM OKC_K_HEADERS_B HDR
12279: , OKC_RULE_GROUPS_B RGP
12280: , OKC_RULES_B RUL
12281: , OKC_K_LINES_B LIN
12282: WHERE HDR.ID = P_HDR_ID

Line 16256: , OKC_K_HEADERS_BH HDR

16252: LEVEL_AMOUNT
16253:
16254: FROM OKC_RULE_GROUPS_BH RGP
16255: , OKC_RULES_BH RUL
16256: , OKC_K_HEADERS_BH HDR
16257: WHERE rgp.id = rul.rgp_id
16258: and rgp.rgd_code = 'SVC_K'
16259: AND RUL.RULE_INFORMATION_CATEGORY IN
16260: ('ARL','CCR','GPR','RVE','IRT','TAX','ERN','QTO', 'RPO', 'RPT','RER', 'RRU',

Line 17018: , OKC_K_HEADERS_BH HDR

17014: LEVEL_AMOUNT
17015:
17016: FROM OKC_RULE_GROUPS_BH RGP
17017: , OKC_RULES_BH RUL
17018: , OKC_K_HEADERS_BH HDR
17019: WHERE rgp.id = rul.rgp_id
17020: and rgp.rgd_code = 'SVC_K'
17021: AND RUL.RULE_INFORMATION_CATEGORY IN
17022: ('ARL','CCR','GPR','RVE','IRT','TAX','ERN','QTO', 'RPO', 'RPT','RER', 'RRU',

Line 17104: FROM OKC_K_HEADERS_BH HDR

17100: , HDR.CONTRACT_NUMBER_MODIFIER
17101: , HDR.MAJOR_VERSION
17102: , RUL.ID
17103: , RGP.ID RGP_ID
17104: FROM OKC_K_HEADERS_BH HDR
17105: , OKC_RULE_GROUPS_BH RGP
17106: , OKC_RULES_BH RUL
17107: WHERE HDR.ID = P_HDR_ID
17108: AND RGP.DNZ_CHR_ID = P_HDR_ID

Line 17127: FROM OKC_K_HEADERS_BH HDR

17123: , LIN.MAJOR_VERSION
17124: , LIN.LINE_NUMBER
17125: , RUL.ID
17126: , RGP.ID RGP_ID
17127: FROM OKC_K_HEADERS_BH HDR
17128: , OKC_RULE_GROUPS_BH RGP
17129: , OKC_RULES_BH RUL
17130: , OKC_K_LINES_BH LIN
17131: WHERE HDR.ID = P_HDR_ID

Line 20384: FROM OKC_K_HEADERS_B

20380: LOCK_EXCEPTION EXCEPTION;
20381: L_LOCK_ID NUMBER;
20382: CURSOR L_LOCK_HDR_CSR (p_id in number ) IS
20383: SELECT ID
20384: FROM OKC_K_HEADERS_B
20385: WHERE ID = P_ID
20386: FOR UPDATE NOWAIT;
20387:
20388: -------------------------------------------------------------------------------

Line 20780: FROM OKC_K_HEADERS_B HDR

20776: SELECT HDR.CONTRACT_NUMBER
20777: , HDR.CONTRACT_NUMBER_MODIFIER
20778: , RUL.ID
20779: , RGP.ID RGP_ID
20780: FROM OKC_K_HEADERS_B HDR
20781: , OKC_RULE_GROUPS_B RGP
20782: , OKC_RULES_B RUL
20783: WHERE HDR.ID = P_HDR_ID
20784: AND RGP.DNZ_CHR_ID = P_HDR_ID

Line 20997: update okc_k_headers_b

20993: iEflag:=0;
20994: Begin
20995: If(l_chr_id is not null) then
20996: begin
20997: update okc_k_headers_b
20998: set conversion_type = l_conversion_type,
20999: conversion_rate = conversion_rate_chr,
21000: conversion_rate_date = conversion_rate_date_chr,
21001: conversion_euro_rate = conversion_euro_rate_chr,

Line 22752: FROM OKC_K_HEADERS_B HDR

22748: , HDR.CONTRACT_NUMBER_MODIFIER
22749: , LIN.LINE_NUMBER
22750: , RUL.ID
22751: , RGP.ID RGP_ID
22752: FROM OKC_K_HEADERS_B HDR
22753: , OKC_RULE_GROUPS_B RGP
22754: , OKC_RULES_B RUL
22755: , OKC_K_LINES_B LIN
22756: WHERE HDR.ID = P_HDR_ID

Line 22800: , okc_k_headers_b okc

22796: , okc.price_list_id
22797: , okc.id
22798: , okcl.lse_id
22799: from oks_k_headers_b oks
22800: , okc_k_headers_b okc
22801: , okc_k_lines_b okcl
22802: , okc_rule_groups_b rgp
22803: where oks.chr_id = okc.id
22804: and okcl.lse_id in ( 1,12,19,46)

Line 24997: FROM OKC_K_HEADERS_BH HDR

24993: , HDR.CONTRACT_NUMBER_MODIFIER
24994: , RUL.MAJOR_VERSION
24995: , RUL.ID
24996: , RGP.ID RGP_ID
24997: FROM OKC_K_HEADERS_BH HDR
24998: , OKC_RULE_GROUPS_BH RGP
24999: , OKC_RULES_BH RUL
25000: WHERE HDR.ID = P_HDR_ID
25001: AND RGP.DNZ_CHR_ID = P_HDR_ID

Line 25375: UPDATE okc_k_headers_bh SET

25371:
25372: if(iEflag = 0) THEN
25373:
25374: BEGIN
25375: UPDATE okc_k_headers_bh SET
25376: CONVERSION_TYPE = L_CONVERSION_TYPE ,
25377: CONVERSION_RATE = CONVERSION_RATE_CHR ,
25378: CONVERSION_RATE_DATE = CONVERSION_RATE_DATE_CHR ,
25379: CONVERSION_EURO_RATE = CONVERSION_EURO_RATE_CHR ,

Line 26369: , okc_k_headers_b okc

26365: , okc.cust_po_number_req_yn
26366: , okc.price_list_id
26367: , okc.id
26368: from oks_k_headers_b oks
26369: , okc_k_headers_b okc
26370: where oks.chr_id = okc.id
26371: and oks.chr_id = p_id;
26372:
26373: -------------------------------------------------------

Line 27026: FROM OKC_K_HEADERS_BH HDR

27022: , LIN.LINE_NUMBER
27023: , RUL.MAJOR_VERSION
27024: , RUL.ID
27025: , RGP.ID RGP_ID
27026: FROM OKC_K_HEADERS_BH HDR
27027: , OKC_RULE_GROUPS_BH RGP
27028: , OKC_RULES_BH RUL
27029: , OKC_K_LINES_BH LIN
27030: WHERE HDR.ID = P_HDR_ID

Line 29081: FROM OKC_K_HEADERS_B

29077: L_LOCK_ID NUMBER;
29078:
29079: CURSOR L_LOCK_HDR_CSR (p_id in number ) IS
29080: SELECT ID
29081: FROM OKC_K_HEADERS_B
29082: WHERE ID = P_ID
29083: FOR UPDATE NOWAIT;
29084:
29085:

Line 29473: FROM OKC_K_HEADERS_B HDR

29469: SELECT HDR.CONTRACT_NUMBER
29470: , HDR.CONTRACT_NUMBER_MODIFIER
29471: , RUL.ID
29472: , RGP.ID RGP_ID
29473: FROM OKC_K_HEADERS_B HDR
29474: , OKC_RULE_GROUPS_B RGP
29475: , OKC_RULES_B RUL
29476: WHERE HDR.ID = P_HDR_ID
29477: AND RGP.DNZ_CHR_ID = P_HDR_ID

Line 29529: , okc_k_headers_b okc

29525: , okc.cust_po_number_req_yn
29526: , okc.price_list_id
29527: , okc.id
29528: from oks_k_headers_b oks
29529: , okc_k_headers_b okc
29530: where oks.chr_id = okc.id
29531: and oks.id = p_id;
29532:
29533: -------------------------------------------------------

Line 29743: UPDATE okc_k_headers_b SET

29739:
29740: If(l_check_var is NULL and l_check_var1 is not null ) THEN
29741:
29742: BEGIN
29743: UPDATE okc_k_headers_b SET
29744: CONVERSION_TYPE = L_CONVERSION_TYPE ,
29745: CONVERSION_RATE = CONVERSION_RATE_CHR ,
29746: CONVERSION_RATE_DATE = CONVERSION_RATE_DATE_CHR ,
29747: CONVERSION_EURO_RATE = CONVERSION_EURO_RATE_CHR ,

Line 29988: --Updating okc_k_headers_b

29984:
29985: END;
29986:
29987: If( Eflag <> 1) Then
29988: --Updating okc_k_headers_b
29989:
29990: BEGIN
29991: UPDATE okc_k_headers_b SET
29992: CONVERSION_TYPE = L_CONVERSION_TYPE ,

Line 29991: UPDATE okc_k_headers_b SET

29987: If( Eflag <> 1) Then
29988: --Updating okc_k_headers_b
29989:
29990: BEGIN
29991: UPDATE okc_k_headers_b SET
29992: CONVERSION_TYPE = L_CONVERSION_TYPE ,
29993: CONVERSION_RATE = CONVERSION_RATE_CHR ,
29994: CONVERSION_RATE_DATE = CONVERSION_RATE_DATE_CHR ,
29995: CONVERSION_EURO_RATE = CONVERSION_EURO_RATE_CHR,

Line 30023: UPDATE okc_k_headers_b SET

30019: Delete from oks_k_headers_b where chr_id = P_CHR_ID;
30020:
30021:
30022:
30023: UPDATE okc_k_headers_b SET
30024: CONVERSION_TYPE = L_CONVERSION_TYPE ,
30025: CONVERSION_RATE = CONVERSION_RATE_CHR ,
30026: CONVERSION_RATE_DATE = CONVERSION_RATE_DATE_CHR ,
30027: CONVERSION_EURO_RATE = CONVERSION_EURO_RATE_CHR ,

Line 31537: FROM OKC_K_HEADERS_B HDR

31533: , HDR.CONTRACT_NUMBER_MODIFIER
31534: , LIN.LINE_NUMBER
31535: , RUL.ID
31536: , RGP.ID RGP_ID
31537: FROM OKC_K_HEADERS_B HDR
31538: , OKC_RULE_GROUPS_B RGP
31539: , OKC_RULES_B RUL
31540: , OKC_K_LINES_B LIN
31541: WHERE HDR.ID = P_HDR_ID

Line 31597: , okc_k_headers_b okc

31593: , okc.price_list_id
31594: , okc.id
31595: , okcl.lse_id
31596: from oks_k_headers_b oks
31597: , okc_k_headers_b okc
31598: , okc_k_lines_b okcl
31599: where oks.chr_id = okc.id
31600: and okcl.lse_id in ( 1,12,19,46)
31601: and okcl.dnz_chr_id = oks.chr_id

Line 33615: FROM OKC_K_HEADERS_BH HDR

33611: , LIN.LINE_NUMBER
33612: , RUL.MAJOR_VERSION
33613: , RUL.ID
33614: , RGP.ID RGP_ID
33615: FROM OKC_K_HEADERS_BH HDR
33616: , OKC_RULE_GROUPS_BH RGP
33617: , OKC_RULES_BH RUL
33618: , OKC_K_LINES_BH LIN
33619: WHERE HDR.ID = P_HDR_ID

Line 35687: FROM OKC_K_HEADERS_BH HDR

35683: , HDR.CONTRACT_NUMBER_MODIFIER
35684: , RUL.MAJOR_VERSION
35685: , RUL.ID
35686: , RGP.ID RGP_ID
35687: FROM OKC_K_HEADERS_BH HDR
35688: , OKC_RULE_GROUPS_BH RGP
35689: , OKC_RULES_BH RUL
35690: WHERE HDR.ID = P_HDR_ID
35691: AND RGP.DNZ_CHR_ID = P_HDR_ID

Line 35909: UPDATE okc_k_headers_bh SET

35905:
35906: If(l_check_var is NULL) THEN
35907:
35908: BEGIN
35909: UPDATE okc_k_headers_bh SET
35910: CONVERSION_TYPE = L_CONVERSION_TYPE ,
35911: CONVERSION_RATE = CONVERSION_RATE_CHR ,
35912: CONVERSION_RATE_DATE = CONVERSION_RATE_DATE_CHR ,
35913: CONVERSION_EURO_RATE = CONVERSION_EURO_RATE_CHR ,

Line 36158: --Updating okc_k_headers_b

36154:
36155: END;
36156:
36157: If( Eflag <> 1) Then
36158: --Updating okc_k_headers_b
36159:
36160: BEGIN
36161: UPDATE okc_k_headers_bh SET
36162: CONVERSION_TYPE = L_CONVERSION_TYPE ,

Line 36161: UPDATE okc_k_headers_bh SET

36157: If( Eflag <> 1) Then
36158: --Updating okc_k_headers_b
36159:
36160: BEGIN
36161: UPDATE okc_k_headers_bh SET
36162: CONVERSION_TYPE = L_CONVERSION_TYPE ,
36163: CONVERSION_RATE = CONVERSION_RATE_CHR ,
36164: CONVERSION_RATE_DATE = CONVERSION_RATE_DATE_CHR ,
36165: CONVERSION_EURO_RATE = CONVERSION_EURO_RATE_CHR,

Line 36195: UPDATE okc_k_headers_bh SET

36191: and major_version = p_major_version;
36192:
36193:
36194:
36195: UPDATE okc_k_headers_bh SET
36196: CONVERSION_TYPE = L_CONVERSION_TYPE ,
36197: CONVERSION_RATE = CONVERSION_RATE_CHR ,
36198: CONVERSION_RATE_DATE = CONVERSION_RATE_DATE_CHR ,
36199: CONVERSION_EURO_RATE = CONVERSION_EURO_RATE_CHR ,

Line 38778: , OKC_K_HEADERS_B OKCH

38774: , OKCH.CUST_PO_NUMBER
38775: , OKCH.CUST_PO_NUMBER_REQ_YN
38776: , OKCH.PRICE_LIST_ID
38777: FROM OKS_RULE_UPGRADE UPG
38778: , OKC_K_HEADERS_B OKCH
38779: WHERE UPG.RIC_CODE = 'LIN'
38780: AND NOT EXISTS ( SELECT 1 FROM OKS_K_LINES_B OKS1
38781: WHERE OKS1.CLE_ID = UPG.RGP_ID )
38782: AND OKCH.ID = UPG.DNZ_CHR_ID