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.CE_PURGE dependencies on CE_STATEMENT_LINES

Line 648: from ce_statement_headers sh, ce_statement_lines sl , ce_statement_reconcils_all sr

644: AND csh.statement_date >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, csh.statement_date)
645: AND csh.statement_date <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, csh.statement_date)
646: AND not exists
647: (select 1 -- find all stmts that are not in ce_security_profiles_gt (cannot delete these stmts)
648: from ce_statement_headers sh, ce_statement_lines sl , ce_statement_reconcils_all sr
649: where sh.statement_header_id = sl.statement_header_id
650: and sl.statement_line_id= sr.statement_line_id
651: and sh.statement_header_id= csh.statement_header_id
652: and sh.bank_account_id = CE_PURGE.G_BANK_ACCOUNT_ID

Line 664: FROM ce_statement_lines csl, ce_statement_reconcils_all csr

660: where lbg.organization_id = sr.org_id or
661: sr.legal_entity_id = lbg.organization_id ) )
662: AND (( CE_PURGE.G_Only_Unrec = 'Y' AND ( NOT EXISTS /*10400780 start*/
663: (SELECT 1
664: FROM ce_statement_lines csl, ce_statement_reconcils_all csr
665: WHERE csl.statement_header_id = csh.statement_header_id
666: and csl.statement_line_id= csr.statement_line_id
667: AND csr.CURRENT_RECORD_FLAG = 'Y'
668: and csr.STATUS_FLAG = 'M'

Line 776: from ce_statement_headers sh, ce_statement_lines sl , ce_statement_reconcils_all sr

772: AND csh.statement_date >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, csh.statement_date)
773: AND csh.statement_date <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, csh.statement_date)
774: AND not exists
775: (select 1 -- find all stmts that are not in ce_security_profiles_gt (cannot delete these stmts)
776: from ce_statement_headers sh, ce_statement_lines sl , ce_statement_reconcils_all sr
777: where sh.statement_header_id = sl.statement_header_id
778: and sl.statement_line_id= sr.statement_line_id
779: and sh.statement_header_id = csh.statement_header_id
780: and sh.bank_account_id IN (SELECT aba.bank_account_id

Line 794: FROM ce_statement_lines csl, ce_statement_reconcils_all csr

790: where lbg.organization_id = sr.org_id or
791: sr.legal_entity_id = lbg.organization_id )
792: ) AND (( CE_PURGE.G_Only_Unrec = 'Y' AND ( NOT EXISTS /*10400780 start*/
793: (SELECT 1
794: FROM ce_statement_lines csl, ce_statement_reconcils_all csr
795: WHERE csl.statement_header_id = csh.statement_header_id
796: and csl.statement_line_id= csr.statement_line_id
797: AND csr.CURRENT_RECORD_FLAG = 'Y'
798: and csr.STATUS_FLAG = 'M'

Line 898: from ce_statement_headers sh, ce_statement_lines sl , ce_statement_reconcils_all sr

894: WHERE csh.statement_date >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, csh.statement_date)
895: AND csh.statement_date <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, csh.statement_date)
896: AND not exists
897: (select 1
898: from ce_statement_headers sh, ce_statement_lines sl , ce_statement_reconcils_all sr
899: where sh.statement_header_id = sl.statement_header_id
900: and sl.statement_line_id= sr.statement_line_id
901: and sh.statement_header_id= csh.statement_header_id
902: and sh.statement_date >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, sh.statement_date)

Line 912: FROM ce_statement_lines csl, ce_statement_reconcils_all csr

908: (select 1 from ce_security_profiles_gt lbg
909: where lbg.organization_id = sr.org_id or sr.legal_entity_id = lbg.organization_id )
910: ) AND (( CE_PURGE.G_Only_Unrec = 'Y' AND ( NOT EXISTS /*10400780 start*/
911: (SELECT 1
912: FROM ce_statement_lines csl, ce_statement_reconcils_all csr
913: WHERE csl.statement_header_id = csh.statement_header_id
914: and csl.statement_line_id= csr.statement_line_id
915: AND csr.CURRENT_RECORD_FLAG = 'Y'
916: and csr.STATUS_FLAG = 'M'

Line 1008: FROM ce_statement_lines

1004: CREATION_DATE,
1005: LAST_UPDATED_BY,
1006: LAST_UPDATE_DATE,
1007: RECONCILE_TO_STATEMENT_FLAG
1008: FROM ce_statement_lines
1009: WHERE statement_header_id IN
1010: ( SELECT statement_header_id
1011: FROM ce_arch_headers );
1012: G_Archive_Stat_Lines := SQL%ROWCOUNT;

Line 1286: FROM ce_statement_lines_interface csl

1282: AMOUNT,
1283: CHARGES_AMOUNT,
1284: CURRENCY_CODE,
1285: USER_EXCHANGE_RATE_TYPE
1286: FROM ce_statement_lines_interface csl
1287: WHERE csl.statement_number ||'-'|| csl.bank_account_num IN (
1288: SELECT csh.statement_number ||'-'|| csh.bank_account_num
1289: FROM ce_statement_headers_int csh
1290: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN (SELECT bb.bank_branch_name

Line 1767: from ce_statement_headers sh, ce_statement_lines sl , ce_statement_reconcils_all sr

1763: AND trunc(csh.statement_date) >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, trunc(csh.statement_date))
1764: AND trunc(csh.statement_date) <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, trunc(csh.statement_date))
1765: AND not exists
1766: (select 1 -- find all stmts that are not in ce_security_profiles_gt (cannot delete these stmts)
1767: from ce_statement_headers sh, ce_statement_lines sl , ce_statement_reconcils_all sr
1768: where sh.statement_header_id = sl.statement_header_id
1769: and sl.statement_line_id= sr.statement_line_id
1770: -- AND sl.status = Decode(G_Only_Unrec,'Y','RECONCILED',sl.status)
1771: and sh.statement_header_id= csh.statement_header_id

Line 1788: FROM ce_statement_lines csl, ce_statement_reconcils_all csr

1784: where lbg.organization_id = sr.org_id or sr.legal_entity_id = lbg.organization_id )
1785: )
1786: AND (( CE_PURGE.G_Only_Unrec = 'Y' AND ( NOT EXISTS /* 10400780 start*/
1787: (SELECT 1
1788: FROM ce_statement_lines csl, ce_statement_reconcils_all csr
1789: WHERE csl.statement_header_id = csh.statement_header_id
1790: and csl.statement_line_id= csr.statement_line_id
1791: AND csr.CURRENT_RECORD_FLAG = 'Y'
1792: and csr.STATUS_FLAG = 'M'

Line 1801: FROM ce_statement_lines csl

1797:
1798: -- Cursor to purge the statement Lines
1799: CURSOR C_PURGE_LINES IS
1800: SELECT csl.statement_line_id
1801: FROM ce_statement_lines csl
1802: WHERE csl.statement_header_id = X_header_id;
1803:
1804: -- Cursor to purge the Intra day statement Headers
1805: CURSOR C_PURGE_INTRA_HEADERS IS

Line 1861: DELETE FROM ce_statement_lines

1857: FETCH C_PURGE_LINES INTO X_line_id;
1858: LOOP
1859: EXIT WHEN c_purge_lines%NOTFOUND;
1860:
1861: DELETE FROM ce_statement_lines
1862: WHERE statement_header_id = X_header_id;
1863: purge_lines := purge_lines + SQL%ROWCOUNT;
1864:
1865: --DELETE FROM ce_statement_reconciliations

Line 1900: DELETE FROM ce_statement_lines_interface csl

1896: IF (CE_PURGE.G_Archive_Purge_Option = 'BOTH')THEN
1897: arch_ce_interface('N');
1898: END IF;
1899:
1900: DELETE FROM ce_statement_lines_interface csl
1901: WHERE csl.statement_number ||'-'|| csl.bank_account_num IN
1902: ( SELECT csh.statement_number ||'-'|| csh.bank_account_num
1903: FROM ce_statement_headers_int csh
1904: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN (SELECT bb.bank_branch_name

Line 1995: DELETE FROM ce_statement_lines_interface csl

1991: IF (CE_PURGE.G_Archive_Purge_Option = 'BOTH')THEN
1992: arch_ce_interface('Y');
1993: END IF;
1994:
1995: DELETE FROM ce_statement_lines_interface csl
1996: WHERE csl.statement_number ||'-'|| csl.bank_account_num IN
1997: ( SELECT csh.statement_number ||'-'|| csh.bank_account_num
1998: FROM ce_statement_headers_int csh
1999: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN (SELECT bb.bank_branch_name

Line 2253: INSERT INTO ce_statement_lines

2249: G_Archive_Stat_Headers := G_Archive_Stat_Headers + SQL%ROWCOUNT;
2250:
2251: cep_standard.debug('>>CE_PURGE.restore_statements G_Archive_Stat_Headers: '||G_Archive_Stat_Headers);
2252:
2253: INSERT INTO ce_statement_lines
2254: (STATEMENT_LINE_ID,
2255: STATEMENT_HEADER_ID,
2256: LINE_NUMBER,
2257: TRX_DATE,

Line 3021: INSERT INTO ce_statement_lines_interface

3017: G_Archive_Inf_Headers2 := G_Archive_Inf_Headers2 + SQL%ROWCOUNT;
3018: END IF;
3019:
3020:
3021: INSERT INTO ce_statement_lines_interface
3022: (EXCHANGE_RATE_DATE,
3023: EXCHANGE_RATE,
3024: BANK_TRX_NUMBER,
3025: CUSTOMER_TEXT,