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_BH

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 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 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 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 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 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 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 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 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 ,