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_SECURITY_PROFILES_GT

Line 470: where org_id in (select org_id from ce_security_profiles_gt) or

466: IF (G_STATEMENT_TYPE IN ('BOTH','PREVIOUS')) THEN
467: IF (G_OBJECTS IN ('BOTH','STATEMENT')) THEN
468:
469: DELETE FROM CE_ARCH_RECONCILIATIONS_all
470: where org_id in (select org_id from ce_security_profiles_gt) or
471: legal_entity_id in (select org_id from ce_security_profiles_gt) or
472: REFERENCE_TYPE in ('JE_LINE', 'ROI_LINE','STATEMENT');
473:
474: DELETE FROM CE_ARCH_RECON_ERRORS;

Line 471: legal_entity_id in (select org_id from ce_security_profiles_gt) or

467: IF (G_OBJECTS IN ('BOTH','STATEMENT')) THEN
468:
469: DELETE FROM CE_ARCH_RECONCILIATIONS_all
470: where org_id in (select org_id from ce_security_profiles_gt) or
471: legal_entity_id in (select org_id from ce_security_profiles_gt) or
472: REFERENCE_TYPE in ('JE_LINE', 'ROI_LINE','STATEMENT');
473:
474: DELETE FROM CE_ARCH_RECON_ERRORS;
475:

Line 647: (select 1 -- find all stmts that are not in ce_security_profiles_gt (cannot delete these stmts)

643: WHERE csh.bank_account_id = CE_PURGE.G_BANK_ACCOUNT_ID
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

Line 659: (select 1 from ce_security_profiles_gt lbg

655: and sr.CURRENT_RECORD_FLAG = 'Y'
656: and sr.STATUS_FLAG = 'M'
657: and (sr.org_id is not null or sr.legal_entity_id is not null)
658: and not exists
659: (select 1 from ce_security_profiles_gt lbg
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

Line 775: (select 1 -- find all stmts that are not in ce_security_profiles_gt (cannot delete these stmts)

771: WHERE aba.bank_branch_id = CE_PURGE.G_BANK_BRANCH_ID)
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

Line 789: (select 1 from ce_security_profiles_gt lbg

785: and sr.CURRENT_RECORD_FLAG = 'Y'
786: and sr.STATUS_FLAG = 'M'
787: and (sr.org_id is not null or sr.legal_entity_id is not null)
788: and not exists
789: (select 1 from ce_security_profiles_gt lbg
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

Line 908: (select 1 from ce_security_profiles_gt lbg

904: and sr.CURRENT_RECORD_FLAG = 'Y'
905: and sr.STATUS_FLAG = 'M'
906: and (sr.org_id is not null or sr.legal_entity_id is not null)
907: and not exists
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

Line 1766: (select 1 -- find all stmts that are not in ce_security_profiles_gt (cannot delete these stmts)

1762: WHERE ba.bank_branch_id = NVL(CE_PURGE.G_BANK_BRANCH_ID,ba.bank_branch_id) )
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)

Line 1783: (select 1 from ce_security_profiles_gt lbg

1779: and sr.CURRENT_RECORD_FLAG = 'Y'
1780: and sr.STATUS_FLAG = 'M'
1781: and (sr.org_id is not null or sr.legal_entity_id is not null)
1782: AND not exists
1783: (select 1 from ce_security_profiles_gt lbg
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

Line 1868: and (org_id in (select organization_id from ce_security_profiles_gt) or

1864:
1865: --DELETE FROM ce_statement_reconciliations
1866: DELETE FROM ce_statement_reconcils_all
1867: WHERE statement_line_id = X_line_id
1868: and (org_id in (select organization_id from ce_security_profiles_gt) or
1869: legal_entity_id in (select organization_id from ce_security_profiles_gt) or
1870: REFERENCE_TYPE in ('JE_LINE', 'ROI_LINE','STATEMENT')
1871: );
1872:

Line 1869: legal_entity_id in (select organization_id from ce_security_profiles_gt) or

1865: --DELETE FROM ce_statement_reconciliations
1866: DELETE FROM ce_statement_reconcils_all
1867: WHERE statement_line_id = X_line_id
1868: and (org_id in (select organization_id from ce_security_profiles_gt) or
1869: legal_entity_id in (select organization_id from ce_security_profiles_gt) or
1870: REFERENCE_TYPE in ('JE_LINE', 'ROI_LINE','STATEMENT')
1871: );
1872:
1873: purge_recons := purge_recons + SQL%ROWCOUNT;

Line 2113: (select 1 -- find all stmts that are not in ce_security_profiles_gt (cannot delete these stmts)

2109: WHERE aba.bank_branch_id = Nvl(CE_PURGE.G_BANK_branch_ID,aba.bank_branch_id)))))
2110: AND csh.statement_date >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, csh.statement_date)
2111: AND csh.statement_date <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, csh.statement_date)
2112: AND not exists
2113: (select 1 -- find all stmts that are not in ce_security_profiles_gt (cannot delete these stmts)
2114: from ce_arch_headers sh, ce_arch_lines sl , ce_arch_reconciliations_all sr
2115: where sh.statement_header_id = sl.statement_header_id
2116: and sl.statement_line_id= sr.statement_line_id
2117: and sh.statement_header_id= csh.statement_header_id

Line 2130: (select 1 from ce_security_profiles_gt lbg

2126: and sr.CURRENT_RECORD_FLAG = 'Y'
2127: and sr.STATUS_FLAG = 'M'
2128: and (sr.org_id is not null or sr.legal_entity_id is not null)
2129: and not exists
2130: (select 1 from ce_security_profiles_gt lbg
2131: where lbg.organization_id = sr.org_id or
2132: sr.legal_entity_id = lbg.organization_id ) )
2133: FOR update;
2134: