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_BILL_MIGRATION dependencies on OKS_BILL_CONT_LINES

Line 385: (SELECT 1 FROM OKS_BILL_CONT_LINES BCL

381: and rel2.cle_id = line2.id
382: and line2.lse_id = 25 )
383: )
384: AND EXISTS
385: (SELECT 1 FROM OKS_BILL_CONT_LINES BCL
386: WHERE BCL.CLE_ID = LINES.ID );
387:
388: l_agg_rec l_header_agg_csr%ROWTYPE;
389: l_subrequests integer;

Line 488: ,oks_bill_cont_lines bcl

484: ,hdr.AUTHORING_ORG_ID
485: From OKC_K_HEADERS_B hdr
486: Where exists (Select 1
487: From okc_k_lines_b ln
488: ,oks_bill_cont_lines bcl
489: Where hdr.id = ln.dnz_chr_id
490: and ln.id = bcl.cle_id );
491:
492: Cursor l_bill_lines_csr(p_dnz_chr_id Number) IS

Line 498: From OKS_BILL_CONT_LINES bcl

494: ,bcl.BTN_ID BtnID
495: ,bcl.CLE_ID LineID
496: ,bcl.AMOUNT Amount
497: ,bcl.CURRENCY_CODE
498: From OKS_BILL_CONT_LINES bcl
499: ,OKC_K_LINES_B kln
500: Where kln.DNZ_CHR_ID = p_dnz_chr_id
501: and bcl.CLE_ID = kln.ID
502: and bcl.BTN_ID is Null

Line 546: Update OKS_BILL_CONT_LINES

542: -- Update currency code for all bill cont lines for this contract -BTN ID not null
543: Begin
544: --dbms_output.put_line('Before Updating the bill cont lines for Contract'||l_cont_rec.ID) ;
545:
546: Update OKS_BILL_CONT_LINES
547: Set CURRENCY_CODE = l_cont_rec.CURRENCY_CODE
548: Where CLE_ID in (select kln.ID
549: from OKC_K_LINES_B kln
550: Where kln.DNZ_CHR_ID = l_cont_rec.ID )

Line 597: Update OKS_BILL_CONT_LINES

593:
594: -- Update Bill Cont Lines with Euro Amount
595: Begin
596: --dbms_output.put_line('Before Updating Converted amount '||l_bill_line_rec.BclID) ;
597: Update OKS_BILL_CONT_LINES
598: Set CURRENCY_CODE = l_euro_code
599: ,AMOUNT = l_euro_amount
600: Where ID = l_bill_line_rec.BclID ;
601: --dbms_output.put_line('After Updating Converted amount '||l_bill_line_rec.BclID) ;

Line 620: Update OKS_BILL_CONT_LINES

616: -- Update currency code for all bill cont lines for this contract -- BTN ID null
617: Begin
618: --dbms_output.put_line('Before Updating the bill cont lines for Contract- BTN ID null'||l_cont_rec.ID) ;
619:
620: Update OKS_BILL_CONT_LINES
621: Set CURRENCY_CODE = l_cont_rec.CURRENCY_CODE
622: Where CLE_ID in (select kln.ID
623: from OKC_K_LINES_B kln
624: Where kln.DNZ_CHR_ID = l_cont_rec.ID )

Line 734: FROM oks_bill_cont_lines

730: --Bill cont lines
731: CURSOR bill_cont_csr (p_cle_id NUMBER) IS
732: SELECT cle_id,
733: amount
734: FROM oks_bill_cont_lines
735: WHERE cle_id = p_cle_id
736: AND bill_action = 'RI';
737:
738: --Bill sub lines

Line 774: FROM oks_bill_cont_lines

770:
771:
772: SELECT COUNT(cle_id)
773: INTO l_bill_count
774: FROM oks_bill_cont_lines
775: WHERE cle_id = top_line_grp_rec.id
776: AND bill_action = 'RI';
777:
778: END IF; --IF top_line_grp_rec.date_terminated IS NOT NULL and < sysdate

Line 804: --get MAX date from oks_bill_cont_lines

800: THEN
801:
802: l_max_date_billed_to := NULL;
803:
804: --get MAX date from oks_bill_cont_lines
805: SELECT MAX(date_billed_to)
806: INTO l_max_date_billed_to
807: FROM oks_bill_cont_lines
808: WHERE cle_id = top_line_grp_rec.id

Line 807: FROM oks_bill_cont_lines

803:
804: --get MAX date from oks_bill_cont_lines
805: SELECT MAX(date_billed_to)
806: INTO l_max_date_billed_to
807: FROM oks_bill_cont_lines
808: WHERE cle_id = top_line_grp_rec.id
809: AND bill_action = 'RI';
810:
811:

Line 952: FROM oks_bill_cont_lines

948: l_bill_count := 0;
949:
950: SELECT COUNT(cle_id)
951: INTO l_bill_count
952: FROM oks_bill_cont_lines
953: WHERE cle_id = top_line_grp_rec.id
954: AND bill_action = 'RI';
955:
956: IF l_bill_count > 0 THEN

Line 1499: FROM oks_bill_cont_lines

1495: --Bill cont lines
1496: CURSOR bill_cont_csr (p_cle_id NUMBER) IS
1497: SELECT cle_id,
1498: amount
1499: FROM oks_bill_cont_lines
1500: WHERE cle_id = p_cle_id
1501: AND bill_action = 'RI';
1502:
1503: --Bill sub lines

Line 1585: FROM oks_bill_cont_lines

1581: l_bill_count := 0;
1582:
1583: SELECT COUNT(cle_id)
1584: INTO l_bill_count
1585: FROM oks_bill_cont_lines
1586: WHERE cle_id = l_id(i)
1587: AND bill_action = 'RI';
1588:
1589: END IF; --IF top_line_date_terminated IS NOT NULL and < sysdate

Line 1842: FROM oks_bill_cont_lines

1838: l_bill_count := 0;
1839:
1840: SELECT COUNT(cle_id)
1841: INTO l_bill_count
1842: FROM oks_bill_cont_lines
1843: WHERE cle_id = l_id(i)
1844: AND bill_action = 'RI';
1845:
1846: IF l_bill_count > 0 THEN

Line 2068: FROM OKS_BILL_CONT_LINES CONT

2064: AND LINE.LSE_ID = 25 ;
2065:
2066: CURSOR L_GET_BCL_ID_CSR ( P_CLE_ID NUMBER ) IS
2067: SELECT CONT.ID
2068: FROM OKS_BILL_CONT_LINES CONT
2069: WHERE CLE_ID = P_CLE_ID ;
2070:
2071: CURSOR L_LINE_AMT_CSR ( P_CLE_ID NUMBER ) IS
2072: SELECT SUM(PRICE_NEGOTIATED)

Line 2079: FROM OKS_BILL_CONT_LINES

2075: AND LINE.LSE_ID = 25 ;
2076:
2077: CURSOR L_BCL_CONT_LINE_EXISTS_CSR ( P_CLE_ID NUMBER ) IS
2078: SELECT ID
2079: FROM OKS_BILL_CONT_LINES
2080: WHERE CLE_ID = P_CLE_ID ;
2081:
2082: CURSOR L_GET_ORDER_NUMBER_CSR ( P_SUB_LINE_ID NUMBER ) IS
2083: SELECT OBJECT1_ID1

Line 2182: insert into oks_bill_cont_lines

2178:
2179: lin_id := get_seq_id;
2180: bcl_id_sub := lin_id;
2181:
2182: insert into oks_bill_cont_lines
2183: (id, cle_id, date_billed_from, date_billed_to, sent_yn, object_version_number,
2184: created_by, creation_date, last_updated_by, last_update_date, bill_action, btn_id)
2185: values
2186: (lin_id, p_top_line_id , p_top_line_start_date, p_top_line_end_date, 'N',

Line 2218: update oks_bill_cont_lines

2214: where id = L_SUB_LINES_REC.ID;
2215:
2216: end loop;
2217:
2218: update oks_bill_cont_lines
2219: set amount = l_line_amount
2220: where id = bcl_id_sub;
2221:
2222: L_LINE_AMOUNT := 0 ;