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_RULE_GROUPS_BH

Line 250: From OKC_RULE_GROUPS_BH rgp ;

246: max(rgp.id) maxid,
247: avg(rgp.id) avgid,
248: stddev(rgp.id) stdid,
249: count(*) total
250: From OKC_RULE_GROUPS_BH rgp ;
251:
252: Cursor l_hdr_agg_csr4 IS
253: Select /*+ PARALLEL(hdr) */
254: min(hdr.id) minid,

Line 508: -- The following csr is on OKC_RULE_GROUPS_BH

504: rc := dbms_sql.execute(trunc_curs);
505: DBMS_SQL.CLOSE_CURSOR(trunc_curs);
506:
507: If (p_status is null and p_org_id is null ) then
508: -- The following csr is on OKC_RULE_GROUPS_BH
509: open l_hdr_agg_csr3;
510: fetch l_hdr_agg_csr3 into l_hdr_agg_rec;
511: close l_hdr_agg_csr3;
512:

Line 770: -- The following csr is on OKC_RULE_GROUPS_BH

766: DBMS_SQL.CLOSE_CURSOR(trunc_curs);
767:
768:
769: If (p_status is null and p_org_id is null ) then
770: -- The following csr is on OKC_RULE_GROUPS_BH
771: open l_hdr_agg_csr3;
772: fetch l_hdr_agg_csr3 into l_hdr_agg_rec;
773: close l_hdr_agg_csr3;
774:

Line 6071: FROM OKC_RULE_GROUPS_BH RGP

6067: '!abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ_,','!'),
6068: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)),NULL,
6069: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)))
6070: LEVEL_AMOUNT
6071: FROM OKC_RULE_GROUPS_BH RGP
6072: , OKC_RULES_BH RUL
6073: WHERE RGP.ID = RUL.RGP_ID
6074: AND RGP.MAJOR_VERSION = RUL.MAJOR_VERSION
6075: AND RGP.DNZ_CHR_ID = RUL.DNZ_CHR_ID

Line 6309: FROM OKC_RULE_GROUPS_BH RGP

6305: '!abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ_,','!'),
6306: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)),NULL,
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',

Line 6547: FROM OKC_RULE_GROUPS_BH RGP

6543: '!abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ_.','!'),
6544: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)),NULL,
6545: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)))
6546: LEVEL_AMOUNT
6547: FROM OKC_RULE_GROUPS_BH RGP
6548: , OKC_RULES_BH RUL
6549: WHERE RGP.ID = RUL.RGP_ID
6550: AND RGP.MAJOR_VERSION = RUL.MAJOR_VERSION
6551: AND RGP.DNZ_CHR_ID = RUL.DNZ_CHR_ID

Line 6785: FROM OKC_RULE_GROUPS_BH RGP

6781: '!abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ_.','!'),
6782: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)),NULL,
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',

Line 6853: , OKC_RULE_GROUPS_BH RGP

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
6857: AND LIN.ID= P_CLE_ID

Line 8537: FROM OKC_RULE_GROUPS_BH RGP

8533: '!abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ_,.','!'),
8534: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)),NULL,
8535: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)))
8536: PRICE_LIST_ID --OKC
8537: FROM OKC_RULE_GROUPS_BH RGP
8538: , OKC_RULES_BH RUL
8539: WHERE rgp.id = rul.rgp_id
8540: and rgp.cle_id is null
8541: and rgp.chr_id is not null

Line 8777: FROM OKC_RULE_GROUPS_BH RGP

8773: '!abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ_,.','!'),
8774: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)),NULL,
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

Line 9018: FROM OKC_RULE_GROUPS_BH RGP

9014: '!abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ_,.','!'),
9015: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)),NULL,
9016: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)))
9017: PRICE_LIST_ID --OKC
9018: FROM OKC_RULE_GROUPS_BH RGP
9019: , OKC_RULES_BH RUL
9020: WHERE rgp.id = rul.rgp_id
9021: and rgp.cle_id is null
9022: and rgp.chr_id is not null

Line 9258: FROM OKC_RULE_GROUPS_BH RGP

9254: '!abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ_,.','!'),
9255: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)),NULL,
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

Line 9323: , OKC_RULE_GROUPS_BH RGP

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
9327: AND RGP.CHR_ID = P_HDR_ID

Line 15873: FROM OKC_RULE_GROUPS_BH RGP

15869: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)),NULL,
15870: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)))
15871: LEVEL_AMOUNT
15872:
15873: FROM OKC_RULE_GROUPS_BH RGP
15874: , OKC_RULES_BH RUL
15875: WHERE rgp.id = rul.rgp_id
15876: AND rgp.rgd_code = 'SVC_K'
15877: AND RUL.RULE_INFORMATION_CATEGORY IN

Line 16254: FROM OKC_RULE_GROUPS_BH RGP

16250: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)),NULL,
16251: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)))
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'

Line 16635: FROM OKC_RULE_GROUPS_BH RGP

16631: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)),NULL,
16632: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)))
16633: LEVEL_AMOUNT
16634:
16635: FROM OKC_RULE_GROUPS_BH RGP
16636: , OKC_RULES_BH RUL
16637: WHERE rgp.id = rul.rgp_id
16638: AND rgp.rgd_code = 'SVC_K'
16639: AND RUL.RULE_INFORMATION_CATEGORY IN

Line 17016: FROM OKC_RULE_GROUPS_BH RGP

17012: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)),NULL,
17013: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)))
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'

Line 17105: , OKC_RULE_GROUPS_BH RGP

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
17109: AND RGP.CHR_ID = P_HDR_ID

Line 17128: , OKC_RULE_GROUPS_BH RGP

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
17132: AND LIN.ID= P_CLE_ID

Line 24780: FROM OKC_RULE_GROUPS_BH RGP

24776: ,MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PTR' ,RUL.OBJECT1_ID1)) PAYMENT_TERM_ID --OKC
24777:
24778: ,TRANSLATE(MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)),
24779: '!,.','!') PRICE_LIST_ID --OKC
24780: FROM OKC_RULE_GROUPS_BH RGP
24781: , OKC_RULES_BH RUL
24782: WHERE rgp.id = rul.rgp_id
24783: and rul.major_version=rgp.major_version
24784: and rgp.cle_id is null

Line 24998: , OKC_RULE_GROUPS_BH RGP

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
25002: AND RGP.CHR_ID = P_HDR_ID

Line 25012: --Cursor to check whether the record exists in OKC_RULE_GROUPS_BH table.

25008: AND RUL.RULE_INFORMATION_CATEGORY = P_CATEGORY ;
25009:
25010: L_HDR_DTLS_REC L_HDR_DTLS_CSR%ROWTYPE;
25011: ----------------------------------------------------------------------------
25012: --Cursor to check whether the record exists in OKC_RULE_GROUPS_BH table.
25013: ----------------------------------------------------------------------------
25014: CURSOR L_CHECK_RGP_CSR ( P_ID IN NUMBER , P_MAJOR_VERSION IN NUMBER ) IS
25015: SELECT CHR_ID
25016: FROM OKC_RULE_GROUPS_BH

Line 25016: FROM OKC_RULE_GROUPS_BH

25012: --Cursor to check whether the record exists in OKC_RULE_GROUPS_BH table.
25013: ----------------------------------------------------------------------------
25014: CURSOR L_CHECK_RGP_CSR ( P_ID IN NUMBER , P_MAJOR_VERSION IN NUMBER ) IS
25015: SELECT CHR_ID
25016: FROM OKC_RULE_GROUPS_BH
25017: WHERE ID = P_ID
25018: AND MAJOR_VERSION = P_MAJOR_VERSION;
25019: ----------------------------------------------------------------------------
25020:

Line 26838: FROM OKC_RULE_GROUPS_BH RGP

26834: -- '!%,','!') DISCOUNT_PERCENT
26835: ,MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'LMT',RUL.RULE_INFORMATION4)) DISCOUNT_PERCENT
26836: ,MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'LMT','N'))Sync_Date_Install
26837:
26838: FROM OKC_RULE_GROUPS_BH RGP
26839: , OKC_RULES_BH RUL
26840: WHERE RGP.ID = RUL.RGP_ID
26841: and rul.major_version=rgp.major_version
26842: AND RUL.RULE_INFORMATION_CATEGORY IN ('DST','ARL','CCR','GPR','IRT','TAX','IBR','PDL','QRE','SLH','CAN','BTO','IRE','LRT','STO','PTR',

Line 27001: FROM OKC_RULE_GROUPS_BH RGP

26997: --,TRANSLATE(MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'LMT',RUL.RULE_INFORMATION4)),
26998: -- '!%. ','!') DISCOUNT_PERCENT
26999: ,MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'LMT',RUL.RULE_INFORMATION4)) DISCOUNT_PERCENT
27000: ,MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'LMT','N'))Sync_Date_Install
27001: FROM OKC_RULE_GROUPS_BH RGP
27002: , OKC_RULES_BH RUL
27003: WHERE RGP.ID = RUL.RGP_ID
27004: and rul.major_version=rgp.major_version
27005: AND RUL.RULE_INFORMATION_CATEGORY IN ('DST','ARL','CCR','GPR','IRT','TAX','IBR','PDL','QRE','SLH','CAN','BTO','IRE','LRT','STO','PTR',

Line 27027: , OKC_RULE_GROUPS_BH RGP

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
27031: AND LIN.ID= P_CLE_ID

Line 27045: --Cursor to check whether the record exists in OKC_RULE_GROUPS_BH table.

27041:
27042: L_LINE_DTLS_REC L_LINE_DTLS_CSR%ROWTYPE;
27043: L_USERENV_LANG VARCHAR2(100) := OKC_UTIL.get_userenv_lang ;
27044: ----------------------------------------------------------------------------
27045: --Cursor to check whether the record exists in OKC_RULE_GROUPS_BH table.
27046: ----------------------------------------------------------------------------
27047: CURSOR L_CHECK_RGP_CSR ( P_ID IN NUMBER , P_MAJOR_VERSION IN NUMBER ) IS
27048: SELECT CLE_ID,DNZ_CHR_ID
27049: FROM OKC_RULE_GROUPS_BH

Line 27049: FROM OKC_RULE_GROUPS_BH

27045: --Cursor to check whether the record exists in OKC_RULE_GROUPS_BH table.
27046: ----------------------------------------------------------------------------
27047: CURSOR L_CHECK_RGP_CSR ( P_ID IN NUMBER , P_MAJOR_VERSION IN NUMBER ) IS
27048: SELECT CLE_ID,DNZ_CHR_ID
27049: FROM OKC_RULE_GROUPS_BH
27050: WHERE ID = P_ID
27051: AND MAJOR_VERSION = P_MAJOR_VERSION;
27052: ----------------------------------------------------------------------------
27053:

Line 33432: FROM OKC_RULE_GROUPS_BH RGP

33428: ,MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'LMT',RUL.RULE_INFORMATION4)) DISCOUNT_PERCENT
33429: ,MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'LMT','N'))Sync_Date_Install
33430: --------------------------------------------------------------------------------------------------------------------
33431:
33432: FROM OKC_RULE_GROUPS_BH RGP
33433: , OKC_RULES_BH RUL
33434: WHERE RGP.ID = RUL.RGP_ID
33435: and rul.major_version=rgp.major_version
33436: AND RUL.RULE_INFORMATION_CATEGORY IN ('DST','ARL','CCR','GPR','IRT','TAX','IBR','PDL','QRE','SLH','CAN','BTO','IRE','LRT','STO','PTR',

Line 33593: FROM OKC_RULE_GROUPS_BH RGP

33589: ,MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'LMT',RUL.RULE_INFORMATION4)) DISCOUNT_PERCENT
33590: ,MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'LMT','N'))Sync_Date_Install
33591: --------------------------------------------------------------------------------------------------------------------
33592:
33593: FROM OKC_RULE_GROUPS_BH RGP
33594: , OKC_RULES_BH RUL
33595: WHERE RGP.ID = RUL.RGP_ID
33596: and rul.major_version=rgp.major_version
33597: AND RUL.RULE_INFORMATION_CATEGORY IN ('DST','ARL','CCR','GPR','IRT','TAX','IBR','PDL','QRE','SLH','CAN','BTO','IRE','LRT','STO','PTR',

Line 33616: , OKC_RULE_GROUPS_BH RGP

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
33620: AND LIN.ID= P_CLE_ID

Line 33646: --in okc_rule_groups_bh

33642: ------------------------------------------------------------------------------
33643:
33644: -----------------------------------------------------------------------------
33645: --Cursor to check if the records corresponding to rgp_id exists
33646: --in okc_rule_groups_bh
33647: -----------------------------------------------------------------------------
33648:
33649: Cursor Cur_RGP_exists(P_RGP_ID in number) IS
33650: select 'x'

Line 33651: from okc_rule_groups_bh

33647: -----------------------------------------------------------------------------
33648:
33649: Cursor Cur_RGP_exists(P_RGP_ID in number) IS
33650: select 'x'
33651: from okc_rule_groups_bh
33652: where id = P_RGP_ID
33653: and cle_id is not null
33654: and major_version = p_major_version;
33655:

Line 35473: FROM OKC_RULE_GROUPS_BH RGP

35469: ,MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PTR' ,RUL.OBJECT1_ID1)) PAYMENT_TERM_ID --OKC
35470:
35471: ,TRANSLATE(MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)),
35472: '!,.','!') PRICE_LIST_ID --OKC
35473: FROM OKC_RULE_GROUPS_BH RGP
35474: , OKC_RULES_BH RUL
35475: WHERE rgp.id = rul.rgp_id
35476: and rul.major_version=rgp.major_version
35477: and rgp.chr_id = P_CHR_ID

Line 35663: FROM OKC_RULE_GROUPS_BH RGP

35659: ,MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PTR' ,RUL.OBJECT1_ID1)) PAYMENT_TERM_ID --OKC
35660:
35661: ,TRANSLATE(MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)),
35662: '!,. ','!') PRICE_LIST_ID --OKC
35663: FROM OKC_RULE_GROUPS_BH RGP
35664: , OKC_RULES_BH RUL
35665: WHERE rgp.id = rul.rgp_id
35666: and rul.major_version=rgp.major_version
35667: and rgp.chr_id = P_CHR_ID

Line 35688: , OKC_RULE_GROUPS_BH RGP

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
35692: AND RGP.CHR_ID = P_HDR_ID

Line 35719: --in okc_rule_groups_bh

35715: ------------------------------------------------------------------------------
35716:
35717: -----------------------------------------------------------------------------
35718: --Cursor to check if the records corresponding to rgp_id exists
35719: --in okc_rule_groups_bh
35720: -----------------------------------------------------------------------------
35721:
35722: Cursor Cur_RGP_exists(P_RGP_ID in number) IS
35723: select 'x'

Line 35724: from okc_rule_groups_bh

35720: -----------------------------------------------------------------------------
35721:
35722: Cursor Cur_RGP_exists(P_RGP_ID in number) IS
35723: select 'x'
35724: from okc_rule_groups_bh
35725: where id = P_RGP_ID
35726: and chr_id is not null
35727: and major_version = p_major_version;
35728:

Line 37477: from okc_rule_groups_bh

37473: and cle_id is not null;
37474:
37475: Cursor Cur_RGPH_exists(P_RGP_ID in number,p_major_version IN NUMBER) IS
37476: select 'x'
37477: from okc_rule_groups_bh
37478: where id = P_RGP_ID
37479: AND major_version = p_major_version
37480: and cle_id is not null;
37481: -----------------------------------------------------------------------------

Line 37500: FROM okc_timevalues_bh TIM,okc_timevalues_bh TIM2 ,okc_rules_bh Rul,OKC_RULE_GROUPS_BH RGP

37496: AND RGP.ID = L_RGP_ID;
37497:
37498: Cursor Cur_Off_Period_H(l_cleid in number,l_rgp_id IN NUMBER,l_major_version IN NUMBER) IS
37499: SELECT TIM2.UOM_CODE,TIM2.DURATION
37500: FROM okc_timevalues_bh TIM,okc_timevalues_bh TIM2 ,okc_rules_bh Rul,OKC_RULE_GROUPS_BH RGP
37501: WHERE RGP.CLE_ID = l_cle_id
37502: AND RUL.rule_information1 = TIM.Id
37503: AND RUL.rule_information_category = 'OFS'
37504: AND RGP.ID = RUL.RGP_ID

Line 37629: FROM okc_timevalues_bh TIM ,okc_timevalues_bh TIM2,okc_rules_bh Rul,OKC_RULE_GROUPS_BH RGP

37625:
37626: UPDATE OKS_K_LINES_BH T1
37627: SET (T1.offset_period ,T1.offset_duration) =
37628: (SELECT TIM2.UOM_CODE,TIM2.DURATION
37629: FROM okc_timevalues_bh TIM ,okc_timevalues_bh TIM2,okc_rules_bh Rul,OKC_RULE_GROUPS_BH RGP
37630: WHERE RGP.CLE_ID = l_cle_id
37631: AND RUL.rule_information1 = TIM.Id
37632: AND RUL.rule_information_category = 'OFS'
37633: AND RGP.ID = RUL.RGP_ID

Line 37721: from okc_rule_groups_bh

37717: and cle_id is not null;
37718:
37719: Cursor Cur_RGPH_exists(P_RGP_ID in number,p_major_version IN NUMBER) IS
37720: select 'x'
37721: from okc_rule_groups_bh
37722: where id = P_RGP_ID
37723: AND major_version = p_major_version
37724: and cle_id is not null;
37725:

Line 37858: from okc_rule_groups_bh rgp,

37854: last_update_login, security_group_id, program_application_id,
37855: program_id, program_update_date, request_id, object_version_number,major_version)
37856: select distinct rgp.cle_id, rgp.cle_id, rgp.dnz_chr_id, times.tze_id, 'Y',
37857: 1, sysdate, 1, sysdate, 2003, null, null, null, null, null,1, times.major_version
37858: from okc_rule_groups_bh rgp,
37859: okc_rules_bh rules,
37860: okc_timevalues_bh times,
37861: okc_cover_times_h cvt
37862: where rgp.id = rules.rgp_id

Line 37898: okc_rule_groups_bh rgp,

37894: sysdate, 1, sysdate, 2003, null, null, null, null, null,tze.major_version, 1
37895: from oks_covtimes_hist_v time_val, --oks_time_ig_startend_val_hv time_val,
37896: okc_cover_times_h cvt,
37897: okc_rules_bh rules,
37898: okc_rule_groups_bh rgp,
37899: oks_coverage_timezones_h tze
37900: where time_val.id = cvt.tve_id
37901: and cvt.rul_id = rules.id
37902: and time_val.dnz_chr_id = cvt.dnz_chr_id

Line 38266: FROM OKC_RULE_GROUPS_BH RGP,

38262: MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'RCN',RUL.RULE_INFORMATION2))RCN_REACT_TIME_NAME,
38263: MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'RCN',RUL.RULE_INFORMATION3))RCN_WORK_THRU_YN,
38264: MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'RCN',RUL.RULE_INFORMATION4))RCN_REACT_ACTIVE_YN,
38265: MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'RSN',RUL.RULE_INFORMATION2))RSN_REACT_TIME_NAME
38266: FROM OKC_RULE_GROUPS_BH RGP,
38267: OKC_RULES_BH RUL
38268: WHERE RGP.ID = RUL.RGP_ID
38269: AND RUL.RULE_INFORMATION_CATEGORY IN ('RCN','RSN')
38270: AND RUL.DNZ_CHR_ID = RGP.DNZ_CHR_ID

Line 38537: okc_rule_groups_bh rgp,

38533: sysdate, 2003, null, null, null, null, null,1, tim.major_version
38534: from okc_timevalues_bh tim,
38535: okc_react_intervals_h rin,
38536: okc_rules_bh rul,
38537: okc_rule_groups_bh rgp,
38538: oks_action_time_types_h att
38539: where att.cle_id = rgp.cle_id
38540: and rgp.id = rul.rgp_id
38541: and rul.rule_information_category in ('RCN', 'RSN')