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

Line 1651: SELECT last_update_date from okc_k_headers_b

1647: l_api_version CONSTANT NUMBER := 1.0;
1648: l_init_msg_list CONSTANT VARCHAR2(1) := 'F';
1649:
1650: Cursor l_contract_update_date(p_chr_id IN NUMBER) is
1651: SELECT last_update_date from okc_k_headers_b
1652: WHERE id = p_chr_id;
1653:
1654:
1655: BEGIN

Line 5398: ,OKC_K_HEADERS_B Hdr

5394: FROM
5395: OKC_K_PARTY_ROLES_B okp
5396: ,OKC_K_LINES_B line
5397: ,OKS_K_LINES_B rline
5398: ,OKC_K_HEADERS_B Hdr
5399: ,OKS_K_HEADERS_B rul
5400: WHERE Hdr.id = p_hdr_id
5401: AND line.id = p_line_id
5402: AND rline.cle_id = line.id

Line 5457: SELECT last_update_date from okc_k_headers_b

5453: AND object1_id1 = to_char(p_chr_id);
5454:
5455:
5456: Cursor l_contract_update_date(p_chr_id IN NUMBER) is
5457: SELECT last_update_date from okc_k_headers_b
5458: WHERE id = p_chr_id;
5459:
5460:
5461:

Line 6301: okc_k_headers_b hdr,

6297: from okc_assents a
6298: where a.opn_code = 'INVOICE'
6299: and a.allowed_yn = 'Y'
6300: ) as1,
6301: okc_k_headers_b hdr,
6302: (
6303: Select distinct code
6304: from okc_statuses_b osb
6305: where osb.ste_code <> 'HOLD'

Line 6398: okc_k_headers_b hdr,

6394: from okc_assents a
6395: where a.opn_code = 'INVOICE'
6396: and a.allowed_yn = 'Y'
6397: ) as1,
6398: okc_k_headers_b hdr,
6399: (
6400: Select distinct code
6401: from okc_statuses_b osb
6402: where osb.ste_code <> 'HOLD'

Line 6438: okc_k_headers_b hdr,

6434: from okc_assents a
6435: where a.opn_code = 'INVOICE'
6436: and a.allowed_yn = 'Y'
6437: ) as1,
6438: okc_k_headers_b hdr,
6439: (
6440: Select distinct code
6441: from okc_statuses_b osb
6442: where osb.ste_code <> 'HOLD'

Line 6486: okc_k_headers_b hdr,

6482: from okc_assents a
6483: where a.opn_code = 'INVOICE'
6484: and a.allowed_yn = 'Y'
6485: ) as1,
6486: okc_k_headers_b hdr,
6487: (
6488: Select distinct code
6489: from okc_statuses_b osb
6490: where osb.ste_code <> 'HOLD'

Line 6527: okc_k_headers_b hdr,

6523: from okc_assents a
6524: where a.opn_code = 'INVOICE'
6525: and a.allowed_yn = 'Y'
6526: ) as1,
6527: okc_k_headers_b hdr,
6528: (
6529: Select distinct code
6530: from okc_statuses_b osb
6531: where osb.ste_code <> 'HOLD'

Line 6566: from okc_k_headers_b hdr, okc_k_lines_b line

6562:
6563: INSERT into oks_process_billing (chr_id,cle_id,line_no,currency_code)
6564:
6565: SELECT hdr.id hdr_id,line.id line_id,rownum,hdr.currency_code
6566: from okc_k_headers_b hdr, okc_k_lines_b line
6567: WHERE Hdr.id = line.dnz_chr_id
6568: AND Hdr.scs_code in ('SERVICE','WARRANTY','SUBSCRIPTION')
6569: AND Hdr.Template_yn = 'N'
6570: AND Hdr.id = p_contract_hdr_id

Line 6618: okc_k_headers_b hdr,

6614: from okc_assents a
6615: where a.opn_code = 'INVOICE'
6616: and a.allowed_yn = 'Y'
6617: ) as1,
6618: okc_k_headers_b hdr,
6619: (
6620: Select /*+ FULL (osb) no_merge */ distinct code
6621: from okc_statuses_b osb
6622: where osb.ste_code <> 'HOLD'

Line 6666: okc_k_headers_b hdr,

6662: from okc_assents a
6663: where a.opn_code = 'INVOICE'
6664: and a.allowed_yn = 'Y'
6665: ) as1,
6666: okc_k_headers_b hdr,
6667: (
6668: Select /*+ FULL (osb) no_merge */ distinct code
6669: from okc_statuses_b osb
6670: where osb.ste_code <> 'HOLD'

Line 6708: from okc_k_headers_b hdr, okc_k_lines_b line

6704: End if;
6705:
6706: INSERT into oks_process_billing (chr_id,cle_id,line_no,currency_code)
6707: SELECT hdr.id hdr_id,line.id line_id,rownum,hdr.currency_code
6708: from okc_k_headers_b hdr, okc_k_lines_b line
6709: WHERE Hdr.id = line.dnz_chr_id
6710: AND Hdr.scs_code in ('SERVICE','WARRANTY','SUBSCRIPTION')
6711: AND Hdr.Template_yn = 'N'
6712: AND Hdr.Authoring_Org_Id = l_org_id

Line 6740: from okc_k_headers_b hdr, okc_k_lines_b line

6736: End if;
6737:
6738: INSERT into oks_process_billing (chr_id,cle_id,line_no,currency_code)
6739: SELECT hdr.id hdr_id,line.id line_id,rownum,hdr.currency_code
6740: from okc_k_headers_b hdr, okc_k_lines_b line
6741: WHERE Hdr.id = line.dnz_chr_id
6742: AND Hdr.scs_code in ('SERVICE','WARRANTY','SUBSCRIPTION')
6743: AND Hdr.Template_yn = 'N'
6744: AND Hdr.Authoring_Org_Id = l_org_id

Line 6771: from okc_k_headers_b hdr, okc_k_lines_b line

6767:
6768: INSERT into oks_process_billing (chr_id,cle_id,line_no,currency_code)
6769:
6770: SELECT hdr.id hdr_id,line.id line_id,rownum,hdr.currency_code
6771: from okc_k_headers_b hdr, okc_k_lines_b line
6772: WHERE Hdr.id = line.dnz_chr_id
6773: AND Hdr.scs_code in ('SERVICE','WARRANTY','SUBSCRIPTION')
6774: AND Hdr.Template_yn = 'N'
6775: AND Hdr.Authoring_Org_Id = nvl(l_org_id, hdr.authoring_org_id)

Line 6998: FROM okc_k_headers_b hdr,

6994: SELECT bcl.cle_id bcl_cle_id,
6995: bsl.cle_id bsl_cle_id,
6996: abs(bsl.amount) bsl_amount,
6997: line.lse_id bcl_lse_id
6998: FROM okc_k_headers_b hdr,
6999: oks_bill_sub_lines bsl,
7000: oks_bill_cont_lines bcl,
7001: okc_k_lines_b line
7002: WHERE line.id = bcl.cle_id

Line 7024: FROM okc_k_headers_b hdr,

7020: SELECT bcl.cle_id bcl_cle_id,
7021: bsl.cle_id bsl_cle_id,
7022: abs(bsl.amount) bsl_amount,
7023: line.lse_id bcl_lse_id
7024: FROM okc_k_headers_b hdr,
7025: oks_bill_sub_lines bsl,
7026: oks_bill_cont_lines bcl,
7027: okc_k_lines_b line
7028: WHERE line.id = bcl.cle_id

Line 7048: FROM okc_k_headers_b hdr,

7044: SELECT bcl.cle_id bcl_cle_id,
7045: bsl.cle_id bsl_cle_id,
7046: abs(bsl.amount) bsl_amount,
7047: line.lse_id bcl_lse_id
7048: FROM okc_k_headers_b hdr,
7049: oks_bill_sub_lines bsl,
7050: oks_bill_cont_lines bcl,
7051: okc_k_lines_b line
7052: WHERE line.id = bcl.cle_id

Line 7119: (SELECT 1 from okc_k_headers_b hdr,

7115: SET bcl.btn_id = NULL
7116: WHERE bcl.btn_id = -44
7117: AND bcl.bill_Action = 'TR'
7118: AND EXISTS
7119: (SELECT 1 from okc_k_headers_b hdr,
7120: okc_k_lines_b line
7121: WHERE line.id = bcl.cle_id
7122: AND hdr.id = line.dnz_chr_id
7123: AND hdr.id = p_contract_hdr_id

Line 7162: (SELECT 1 from okc_k_headers_b hdr,

7158: SET bcl.btn_id = NULL
7159: WHERE bcl.btn_id = -44
7160: AND bcl.bill_Action = 'TR'
7161: AND EXISTS
7162: (SELECT 1 from okc_k_headers_b hdr,
7163: okc_k_lines_b line
7164: WHERE line.id = bcl.cle_id
7165: AND hdr.id = line.dnz_chr_id
7166: AND hdr.scs_code = nvl(p_category,hdr.scs_code)

Line 7186: (SELECT 1 from okc_k_headers_b hdr,

7182: SET bcl.btn_id = NULL
7183: WHERE bcl.btn_id = -44
7184: AND bcl.bill_Action = 'TR'
7185: AND EXISTS
7186: (SELECT 1 from okc_k_headers_b hdr,
7187: okc_k_lines_b line
7188: WHERE line.id = bcl.cle_id
7189: AND hdr.id = line.dnz_chr_id
7190: AND hdr.id = nvl(p_contract_hdr_id,hdr.id)