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_BANK_ACCTS_GT_V

Line 231: FROM ce_bank_accts_gt_v ba

227: AND csh.org_id = cah.org_id
228: AND trunc(csh.statement_date) >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, trunc(csh.statement_date))
229: AND trunc(csh.statement_date) <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, trunc(csh.statement_date))
230: AND csh.bank_account_id IN (SELECT bank_account_id
231: FROM ce_bank_accts_gt_v ba
232: WHERE ba.bank_branch_id = NVL(CE_PURGE.G_BANK_BRANCH_ID,ba.bank_branch_id))
233: AND csh.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,csh.bank_account_id)));
234:
235: IF( G_Archive_Purge_Option = 'Restore' ) THEN

Line 249: FROM ce_bank_accts_gt_v ba

245: AND csh.org_id = cah.org_id
246: AND trunc(csh.statement_date) >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, trunc(csh.statement_date))
247: AND trunc(csh.statement_date) <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, trunc(csh.statement_date))
248: AND csh.bank_account_id IN (SELECT bank_account_id
249: FROM ce_bank_accts_gt_v ba
250: WHERE ba.bank_branch_id = NVL(CE_PURGE.G_BANK_BRANCH_ID,ba.bank_branch_id))
251: AND csh.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,csh.bank_account_id));
252:
253: IF( G_Archive_Purge_Option = 'Restore' ) THEN

Line 267: FROM ce_bank_accts_gt_v ba

263: AND csh.org_id = cah.org_id
264: AND trunc(csh.statement_date) >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, trunc(csh.statement_date))
265: AND trunc(csh.statement_date) <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, trunc(csh.statement_date))
266: AND csh.bank_account_id IN (SELECT bank_account_id
267: FROM ce_bank_accts_gt_v ba
268: WHERE ba.bank_branch_id = NVL(CE_PURGE.G_BANK_BRANCH_ID,ba.bank_branch_id))
269: AND csh.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,csh.bank_account_id));
270:
271: IF( G_Archive_Purge_Option = 'Restore' ) THEN

Line 285: FROM ce_bank_accts_gt_v ba

281: AND csh.org_id = cah.org_id
282: AND trunc(csh.statement_date) >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, trunc(csh.statement_date))
283: AND trunc(csh.statement_date) <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, trunc(csh.statement_date))
284: AND csh.bank_account_id IN (SELECT bank_account_id
285: FROM ce_bank_accts_gt_v ba
286: WHERE ba.bank_branch_id = NVL(CE_PURGE.G_BANK_BRANCH_ID,ba.bank_branch_id))
287: AND csh.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,csh.bank_account_id));
288:
289: IF( G_Archive_Purge_Option = 'Restore' ) THEN

Line 302: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba

298: WHERE cal.statement_number ||'-'|| cal.bank_account_num IN
299: ( SELECT csh.statement_number ||'-'|| csh.bank_account_num
300: FROM ce_statement_headers_int csh
301: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN (SELECT bb.bank_branch_name
302: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba
303: WHERE bb.branch_party_id = ba.bank_branch_id
304: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)
305: AND bb.branch_party_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bb.branch_party_id))
306: AND csh.bank_account_num IN (SELECT bank_account_num

Line 307: FROM ce_bank_accts_gt_v

303: WHERE bb.branch_party_id = ba.bank_branch_id
304: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)
305: AND bb.branch_party_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bb.branch_party_id))
306: AND csh.bank_account_num IN (SELECT bank_account_num
307: FROM ce_bank_accts_gt_v
308: WHERE bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,bank_account_id)
309: AND bank_branch_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bank_branch_id))
310: AND trunc(csh.statement_date) >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, trunc(csh.statement_date))
311: AND trunc(csh.statement_date) <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, trunc(csh.statement_date))

Line 325: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba

321: ( SELECT csh.statement_number ||'-'|| csh.bank_account_num
322: FROM ce_statement_headers_int csh
323: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN
324: (SELECT bb.bank_branch_name
325: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba
326: WHERE bb.branch_party_id = ba.bank_branch_id
327: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)
328: AND bb.branch_party_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bb.branch_party_id))
329: AND csh.bank_account_num IN

Line 331: FROM ce_bank_accts_gt_v

327: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)
328: AND bb.branch_party_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bb.branch_party_id))
329: AND csh.bank_account_num IN
330: (SELECT bank_account_num
331: FROM ce_bank_accts_gt_v
332: WHERE bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,bank_account_id)
333: AND bank_branch_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bank_branch_id))
334: AND trunc(csh.statement_date) >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, trunc(csh.statement_date))
335: AND trunc(csh.statement_date) <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, trunc(csh.statement_date))

Line 359: FROM ce_bank_accts_gt_v ba

355: AND cah.bank_account_id = csh.bank_account_id
356: AND csh.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,csh.bank_account_id)
357: AND csh.bank_account_id IN
358: (SELECT bank_account_id
359: FROM ce_bank_accts_gt_v ba
360: WHERE ba.bank_branch_id = NVL(CE_PURGE.G_BANK_BRANCH_ID,ba.bank_branch_id) )
361: AND trunc(csh.statement_date) >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, trunc(csh.statement_date))
362: AND trunc(csh.statement_date) <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, trunc(csh.statement_date)));
363:

Line 378: FROM ce_bank_accts_gt_v ba

374: AND cah.bank_account_id = csh.bank_account_id
375: AND csh.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,csh.bank_account_id)
376: AND csh.bank_account_id IN
377: (SELECT bank_account_id
378: FROM ce_bank_accts_gt_v ba
379: WHERE ba.bank_branch_id = NVL(CE_PURGE.G_BANK_BRANCH_ID,ba.bank_branch_id) )
380: AND trunc(csh.statement_date) >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, trunc(csh.statement_date))
381: AND trunc(csh.statement_date) <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, trunc(csh.statement_date)));
382:

Line 398: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba

394: ( SELECT csh.statement_number ||'-'|| csh.bank_account_num
395: FROM ce_statement_headers_int csh
396: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN (
397: SELECT bb.bank_branch_name
398: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba
399: WHERE bb.branch_party_id = ba.bank_branch_id
400: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)
401: AND bb.branch_party_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bb.branch_party_id))
402: AND csh.bank_account_num IN

Line 404: FROM ce_bank_accts_gt_v

400: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)
401: AND bb.branch_party_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bb.branch_party_id))
402: AND csh.bank_account_num IN
403: (SELECT bank_account_num
404: FROM ce_bank_accts_gt_v
405: WHERE bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,bank_account_id)
406: AND bank_branch_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bank_branch_id))
407: AND trunc(csh.statement_date) >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, trunc(csh.statement_date))
408: AND trunc(csh.statement_date) <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, trunc(csh.statement_date))

Line 423: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba

419: (SELECT csh.statement_number ||'-'|| csh.bank_account_num
420: FROM ce_statement_headers_int csh
421: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN
422: (SELECT bb.bank_branch_name
423: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba
424: WHERE bb.branch_party_id = ba.bank_branch_id
425: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)
426: AND bb.branch_party_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bb.branch_party_id))
427: AND csh.bank_account_num IN

Line 429: FROM ce_bank_accts_gt_v

425: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)
426: AND bb.branch_party_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bb.branch_party_id))
427: AND csh.bank_account_num IN
428: (SELECT bank_account_num
429: FROM ce_bank_accts_gt_v
430: WHERE bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,bank_account_id)
431: AND bank_branch_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bank_branch_id))
432: AND trunc(csh.statement_date) >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, trunc(csh.statement_date))
433: AND trunc(csh.statement_date) <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, trunc(csh.statement_date))

Line 770: FROM CE_BANK_ACCTS_GT_V aba

766: LAST_UPDATED_BY,
767: LAST_UPDATE_DATE
768: FROM ce_statement_headers csh
769: WHERE csh.bank_account_id IN (SELECT aba.bank_account_id
770: FROM CE_BANK_ACCTS_GT_V aba
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

Line 781: FROM ce_bank_accounts aba --CE_BANK_ACCTS_GT_V aba

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
781: FROM ce_bank_accounts aba --CE_BANK_ACCTS_GT_V aba
782: WHERE aba.bank_branch_id = CE_PURGE.G_BANK_BRANCH_ID)
783: AND sh.statement_date >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, sh.statement_date)
784: AND sh.statement_date <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, sh.statement_date)
785: and sr.CURRENT_RECORD_FLAG = 'Y'

Line 1190: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba

1186: INTRA_DAY_FLAG
1187: --ORG_ID
1188: FROM ce_statement_headers_int csh
1189: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN (SELECT bb.bank_branch_name
1190: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba
1191: WHERE bb.branch_party_id = ba.bank_branch_id
1192: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)
1193: AND bb.branch_party_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bb.branch_party_id))
1194: AND csh.bank_account_num IN (SELECT bank_account_num

Line 1195: FROM ce_bank_accts_gt_v

1191: WHERE bb.branch_party_id = ba.bank_branch_id
1192: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)
1193: AND bb.branch_party_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bb.branch_party_id))
1194: AND csh.bank_account_num IN (SELECT bank_account_num
1195: FROM ce_bank_accts_gt_v
1196: WHERE bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,bank_account_id)
1197: AND bank_branch_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bank_branch_id))
1198: AND trunc(csh.statement_date) >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, trunc(csh.statement_date))
1199: AND trunc(csh.statement_date) <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, trunc(csh.statement_date))

Line 1291: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba

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
1291: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba
1292: WHERE bb.branch_party_id = ba.bank_branch_id
1293: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)
1294: AND bb.branch_party_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bb.branch_party_id))
1295: AND csh.bank_account_num IN (SELECT cv.bank_account_num

Line 1296: FROM ce_bank_accts_gt_v cv

1292: WHERE bb.branch_party_id = ba.bank_branch_id
1293: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)
1294: AND bb.branch_party_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bb.branch_party_id))
1295: AND csh.bank_account_num IN (SELECT cv.bank_account_num
1296: FROM ce_bank_accts_gt_v cv
1297: WHERE cv.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,cv.bank_account_id)
1298: AND cv.bank_branch_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, cv.bank_branch_id))
1299: AND trunc(csh.statement_date) >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, trunc(csh.statement_date))
1300: AND trunc(csh.statement_date) <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, trunc(csh.statement_date))

Line 1748: -- 1) Main query - should query from security view (ce_bank_accts_gt_v)

1744: -- bug 3676745 in order to archive/purge stmts, the user
1745: -- must have access to all the reconciled trx's
1746: -- org (ce_statement_reconcils_all.org_id and ce_statement_reconcils_all.legal_entity_id)
1747: -- This is to ensure that there are no orphan trx data in the system
1748: -- 1) Main query - should query from security view (ce_bank_accts_gt_v)
1749: -- 2) Sub-query (not exists) should select from ce_bank_accounts table,
1750: -- This query is to select all stmts that the users do not have access to.
1751: -- If stmts exists in this subquery then the stmt should not be deleted.
1752: -- This is to ensure that there are no orphan trx data in the system

Line 1761: FROM ce_bank_accts_gt_v ba

1757: FROM ce_statement_headers csh
1758: WHERE csh.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,bank_account_id)
1759: AND csh.bank_account_id IN
1760: (SELECT bank_account_id
1761: FROM ce_bank_accts_gt_v ba
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

Line 1775: FROM ce_bank_accounts ba --ce_bank_accts_gt_v ba

1771: and sh.statement_header_id= csh.statement_header_id
1772: and sh.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,bank_account_id)
1773: AND sh.bank_account_id IN
1774: (SELECT bank_account_id
1775: FROM ce_bank_accounts ba --ce_bank_accts_gt_v ba
1776: WHERE ba.bank_branch_id = NVL(CE_PURGE.G_BANK_BRANCH_ID,ba.bank_branch_id) )
1777: AND trunc(sh.statement_date) >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, trunc(sh.statement_date))
1778: AND trunc(sh.statement_date) <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, trunc(sh.statement_date))
1779: and sr.CURRENT_RECORD_FLAG = 'Y'

Line 1811: FROM ce_bank_accts_gt_v ba

1807: FROM ce_intra_stmt_headers csh
1808: WHERE csh.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,bank_account_id)
1809: AND csh.bank_account_id IN
1810: (SELECT bank_account_id
1811: FROM ce_bank_accts_gt_v ba
1812: WHERE ba.bank_branch_id = NVL(CE_PURGE.G_BANK_BRANCH_ID,ba.bank_branch_id) )
1813: AND trunc(csh.statement_date) >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, trunc(csh.statement_date))
1814: AND trunc(csh.statement_date) <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, trunc(csh.statement_date));
1815:

Line 1905: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba

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
1905: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba
1906: WHERE bb.branch_party_id = ba.bank_branch_id
1907: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)
1908: AND bb.branch_party_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bb.branch_party_id))
1909: AND csh.bank_account_num IN (SELECT bank_account_num

Line 1910: FROM ce_bank_accts_gt_v

1906: WHERE bb.branch_party_id = ba.bank_branch_id
1907: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)
1908: AND bb.branch_party_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bb.branch_party_id))
1909: AND csh.bank_account_num IN (SELECT bank_account_num
1910: FROM ce_bank_accts_gt_v
1911: WHERE bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,bank_account_id)
1912: AND bank_branch_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bank_branch_id))
1913: AND trunc(csh.statement_date) >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, trunc(csh.statement_date))
1914: AND trunc(csh.statement_date) <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, trunc(csh.statement_date))

Line 1923: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba

1919:
1920: DELETE FROM ce_statement_headers_int csh
1921: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN
1922: (SELECT bb.bank_branch_name
1923: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba
1924: WHERE bb.branch_party_id = ba.bank_branch_id
1925: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)
1926: AND bb.branch_party_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bb.branch_party_id))
1927: AND csh.bank_account_num IN

Line 1929: FROM ce_bank_accts_gt_v

1925: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)
1926: AND bb.branch_party_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bb.branch_party_id))
1927: AND csh.bank_account_num IN
1928: (SELECT bank_account_num
1929: FROM ce_bank_accts_gt_v
1930: WHERE bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,bank_account_id)
1931: AND bank_branch_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bank_branch_id))
1932: AND trunc(csh.statement_date) >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, trunc(csh.statement_date))
1933: AND trunc(csh.statement_date) <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, trunc(csh.statement_date))

Line 2000: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba

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
2000: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba
2001: WHERE bb.branch_party_id = ba.bank_branch_id
2002: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)
2003: AND bb.branch_party_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bb.branch_party_id))
2004: AND csh.bank_account_num IN

Line 2006: FROM ce_bank_accts_gt_v

2002: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)
2003: AND bb.branch_party_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bb.branch_party_id))
2004: AND csh.bank_account_num IN
2005: (SELECT bank_account_num
2006: FROM ce_bank_accts_gt_v
2007: WHERE bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,bank_account_id)
2008: AND bank_branch_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bank_branch_id))
2009: AND trunc(csh.statement_date) >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, trunc(csh.statement_date))
2010: AND trunc(csh.statement_date) <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, trunc(csh.statement_date))

Line 2019: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba

2015:
2016: DELETE FROM ce_statement_headers_int csh
2017: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN
2018: (SELECT bb.bank_branch_name
2019: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba
2020: WHERE bb.branch_party_id = ba.bank_branch_id
2021: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)
2022: AND bb.branch_party_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bb.branch_party_id))
2023: AND csh.bank_account_num IN

Line 2025: FROM ce_bank_accts_gt_v

2021: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)
2022: AND bb.branch_party_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bb.branch_party_id))
2023: AND csh.bank_account_num IN
2024: (SELECT bank_account_num
2025: FROM ce_bank_accts_gt_v
2026: WHERE bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,bank_account_id)
2027: AND bank_branch_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bank_branch_id))
2028: AND trunc(csh.statement_date) >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, trunc(csh.statement_date))
2029: AND trunc(csh.statement_date) <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, trunc(csh.statement_date))

Line 2108: FROM ce_bank_accounts aba --CE_BANK_ACCTS_GT_V aba

2104: WHERE ( csh.bank_account_id = Nvl(CE_PURGE.G_BANK_ACCOUNT_ID,-1)
2105: OR
2106: (CE_PURGE.G_BANK_ACCOUNT_ID IS NULL
2107: AND (csh.bank_account_id in (SELECT aba.bank_account_id
2108: FROM ce_bank_accounts aba --CE_BANK_ACCTS_GT_V aba
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

Line 2122: FROM ce_bank_accounts aba --CE_BANK_ACCTS_GT_V aba

2118: and ( csh.bank_account_id = Nvl(CE_PURGE.G_BANK_ACCOUNT_ID,-1)
2119: OR
2120: (CE_PURGE.G_BANK_ACCOUNT_ID IS NULL
2121: AND (sh.bank_account_id in (SELECT aba.bank_account_id
2122: FROM ce_bank_accounts aba --CE_BANK_ACCTS_GT_V aba
2123: WHERE aba.bank_branch_id = Nvl(CE_PURGE.G_BANK_branch_ID,aba.bank_branch_id)))))
2124: AND sh.statement_date >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, sh.statement_date)
2125: AND sh.statement_date <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, sh.statement_date)
2126: and sr.CURRENT_RECORD_FLAG = 'Y'

Line 2861: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba

2857: intra_day_flag,
2858: ORG_ID
2859: FROM ce_arch_interface_headers csh
2860: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN (SELECT bb.bank_branch_name
2861: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba
2862: WHERE bb.branch_party_id = ba.bank_branch_id
2863: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)
2864: AND bb.branch_party_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bb.branch_party_id))
2865: AND csh.bank_account_num IN (SELECT bank_account_num

Line 2866: FROM ce_bank_accts_gt_v

2862: WHERE bb.branch_party_id = ba.bank_branch_id
2863: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)
2864: AND bb.branch_party_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bb.branch_party_id))
2865: AND csh.bank_account_num IN (SELECT bank_account_num
2866: FROM ce_bank_accts_gt_v
2867: WHERE bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,bank_account_id)
2868: AND bank_branch_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bank_branch_id))
2869: AND trunc(csh.statement_date) >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, trunc(csh.statement_date))
2870: AND trunc(csh.statement_date) <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, trunc(csh.statement_date))

Line 3274: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba

3270: G_Bank_Branch_Name,
3271: G_Bank_Account_Name,
3272: G_Bank_Account_Num,
3273: G_Currency_Code
3274: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba
3275: WHERE ba.bank_account_id = G_BANK_ACCOUNT_ID
3276: AND bb.branch_party_id = ba.bank_branch_id;
3277:
3278:

Line 3311: FROM CE_BANK_ACCTS_GT_V

3307:
3308: IF (G_BANK_ACCOUNT_ID IS NOT NULL AND G_BANK_BRANCH_ID IS NOT NULL) THEN
3309: SELECT BANK_BRANCH_ID
3310: INTO l_bank_branch_id
3311: FROM CE_BANK_ACCTS_GT_V
3312: WHERE BANK_ACCOUNT_ID = G_BANK_ACCOUNT_ID;
3313:
3314: IF (l_bank_branch_id <> G_BANK_BRANCH_ID) THEN
3315: FND_MESSAGE.set_name('CE','CE_PURGE_BRANCH_ACCOUNT');