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.GMA_PURGE_ENGINE dependencies on IC_JRNL_MST

Line 1689: cursor c1(P_MINJRNL ic_jrnl_mst.journal_no%type,

1685: select crit_tag,crit_value
1686: from sy_purg_mst_crit
1687: where purge_id=P_Purge_id;
1688:
1689: cursor c1(P_MINJRNL ic_jrnl_mst.journal_no%type,
1690: P_MAXJRNL ic_jrnl_mst.journal_no%type,
1691: P_MINORGN ic_jrnl_mst.orgn_code%type,
1692: P_MAXORGN ic_jrnl_mst.orgn_code%type,
1693: P_MINMDATE ic_jrnl_mst.last_update_date%type,

Line 1690: P_MAXJRNL ic_jrnl_mst.journal_no%type,

1686: from sy_purg_mst_crit
1687: where purge_id=P_Purge_id;
1688:
1689: cursor c1(P_MINJRNL ic_jrnl_mst.journal_no%type,
1690: P_MAXJRNL ic_jrnl_mst.journal_no%type,
1691: P_MINORGN ic_jrnl_mst.orgn_code%type,
1692: P_MAXORGN ic_jrnl_mst.orgn_code%type,
1693: P_MINMDATE ic_jrnl_mst.last_update_date%type,
1694: P_MAXMDATE ic_jrnl_mst.last_update_date%type,

Line 1691: P_MINORGN ic_jrnl_mst.orgn_code%type,

1687: where purge_id=P_Purge_id;
1688:
1689: cursor c1(P_MINJRNL ic_jrnl_mst.journal_no%type,
1690: P_MAXJRNL ic_jrnl_mst.journal_no%type,
1691: P_MINORGN ic_jrnl_mst.orgn_code%type,
1692: P_MAXORGN ic_jrnl_mst.orgn_code%type,
1693: P_MINMDATE ic_jrnl_mst.last_update_date%type,
1694: P_MAXMDATE ic_jrnl_mst.last_update_date%type,
1695: P_MINCDATE ic_jrnl_mst.creation_date%type,

Line 1692: P_MAXORGN ic_jrnl_mst.orgn_code%type,

1688:
1689: cursor c1(P_MINJRNL ic_jrnl_mst.journal_no%type,
1690: P_MAXJRNL ic_jrnl_mst.journal_no%type,
1691: P_MINORGN ic_jrnl_mst.orgn_code%type,
1692: P_MAXORGN ic_jrnl_mst.orgn_code%type,
1693: P_MINMDATE ic_jrnl_mst.last_update_date%type,
1694: P_MAXMDATE ic_jrnl_mst.last_update_date%type,
1695: P_MINCDATE ic_jrnl_mst.creation_date%type,
1696: P_MAXCDATE ic_jrnl_mst.creation_date%type)

Line 1693: P_MINMDATE ic_jrnl_mst.last_update_date%type,

1689: cursor c1(P_MINJRNL ic_jrnl_mst.journal_no%type,
1690: P_MAXJRNL ic_jrnl_mst.journal_no%type,
1691: P_MINORGN ic_jrnl_mst.orgn_code%type,
1692: P_MAXORGN ic_jrnl_mst.orgn_code%type,
1693: P_MINMDATE ic_jrnl_mst.last_update_date%type,
1694: P_MAXMDATE ic_jrnl_mst.last_update_date%type,
1695: P_MINCDATE ic_jrnl_mst.creation_date%type,
1696: P_MAXCDATE ic_jrnl_mst.creation_date%type)
1697:

Line 1694: P_MAXMDATE ic_jrnl_mst.last_update_date%type,

1690: P_MAXJRNL ic_jrnl_mst.journal_no%type,
1691: P_MINORGN ic_jrnl_mst.orgn_code%type,
1692: P_MAXORGN ic_jrnl_mst.orgn_code%type,
1693: P_MINMDATE ic_jrnl_mst.last_update_date%type,
1694: P_MAXMDATE ic_jrnl_mst.last_update_date%type,
1695: P_MINCDATE ic_jrnl_mst.creation_date%type,
1696: P_MAXCDATE ic_jrnl_mst.creation_date%type)
1697:
1698: is

Line 1695: P_MINCDATE ic_jrnl_mst.creation_date%type,

1691: P_MINORGN ic_jrnl_mst.orgn_code%type,
1692: P_MAXORGN ic_jrnl_mst.orgn_code%type,
1693: P_MINMDATE ic_jrnl_mst.last_update_date%type,
1694: P_MAXMDATE ic_jrnl_mst.last_update_date%type,
1695: P_MINCDATE ic_jrnl_mst.creation_date%type,
1696: P_MAXCDATE ic_jrnl_mst.creation_date%type)
1697:
1698: is
1699: select distinct IA1.doc_id

Line 1696: P_MAXCDATE ic_jrnl_mst.creation_date%type)

1692: P_MAXORGN ic_jrnl_mst.orgn_code%type,
1693: P_MINMDATE ic_jrnl_mst.last_update_date%type,
1694: P_MAXMDATE ic_jrnl_mst.last_update_date%type,
1695: P_MINCDATE ic_jrnl_mst.creation_date%type,
1696: P_MAXCDATE ic_jrnl_mst.creation_date%type)
1697:
1698: is
1699: select distinct IA1.doc_id
1700: FROM ic_adjs_jnl IA1,

Line 1701: ic_jrnl_mst IJ1

1697:
1698: is
1699: select distinct IA1.doc_id
1700: FROM ic_adjs_jnl IA1,
1701: ic_jrnl_mst IJ1
1702: WHERE IA1.journal_id = IJ1.journal_id
1703: AND IJ1.posted_ind = 1
1704: AND IA1.completed_ind = 1
1705: AND IJ1.journal_no >= P_MINJRNL

Line 1726: MINJRNL ic_jrnl_mst.journal_no%type;

1722: --excludes ('GRDI','GRDR','STSI','STSR') types per bug 2441842
1723: -- Bug #2602036 (JKB) Removed 'upper' and 'not in' above.
1724: and gl_posted_ind <> 1;
1725:
1726: MINJRNL ic_jrnl_mst.journal_no%type;
1727: MAXJRNL ic_jrnl_mst.journal_no%type;
1728: MINORGN ic_jrnl_mst.orgn_code%type;
1729: MAXORGN ic_jrnl_mst.orgn_code%type;
1730: MINMDATE ic_jrnl_mst.last_update_date%type;

Line 1727: MAXJRNL ic_jrnl_mst.journal_no%type;

1723: -- Bug #2602036 (JKB) Removed 'upper' and 'not in' above.
1724: and gl_posted_ind <> 1;
1725:
1726: MINJRNL ic_jrnl_mst.journal_no%type;
1727: MAXJRNL ic_jrnl_mst.journal_no%type;
1728: MINORGN ic_jrnl_mst.orgn_code%type;
1729: MAXORGN ic_jrnl_mst.orgn_code%type;
1730: MINMDATE ic_jrnl_mst.last_update_date%type;
1731: MAXMDATE ic_jrnl_mst.last_update_date%type;

Line 1728: MINORGN ic_jrnl_mst.orgn_code%type;

1724: and gl_posted_ind <> 1;
1725:
1726: MINJRNL ic_jrnl_mst.journal_no%type;
1727: MAXJRNL ic_jrnl_mst.journal_no%type;
1728: MINORGN ic_jrnl_mst.orgn_code%type;
1729: MAXORGN ic_jrnl_mst.orgn_code%type;
1730: MINMDATE ic_jrnl_mst.last_update_date%type;
1731: MAXMDATE ic_jrnl_mst.last_update_date%type;
1732: MINCDATE ic_jrnl_mst.creation_date%type;

Line 1729: MAXORGN ic_jrnl_mst.orgn_code%type;

1725:
1726: MINJRNL ic_jrnl_mst.journal_no%type;
1727: MAXJRNL ic_jrnl_mst.journal_no%type;
1728: MINORGN ic_jrnl_mst.orgn_code%type;
1729: MAXORGN ic_jrnl_mst.orgn_code%type;
1730: MINMDATE ic_jrnl_mst.last_update_date%type;
1731: MAXMDATE ic_jrnl_mst.last_update_date%type;
1732: MINCDATE ic_jrnl_mst.creation_date%type;
1733: MAXCDATE ic_jrnl_mst.creation_date%type;

Line 1730: MINMDATE ic_jrnl_mst.last_update_date%type;

1726: MINJRNL ic_jrnl_mst.journal_no%type;
1727: MAXJRNL ic_jrnl_mst.journal_no%type;
1728: MINORGN ic_jrnl_mst.orgn_code%type;
1729: MAXORGN ic_jrnl_mst.orgn_code%type;
1730: MINMDATE ic_jrnl_mst.last_update_date%type;
1731: MAXMDATE ic_jrnl_mst.last_update_date%type;
1732: MINCDATE ic_jrnl_mst.creation_date%type;
1733: MAXCDATE ic_jrnl_mst.creation_date%type;
1734:

Line 1731: MAXMDATE ic_jrnl_mst.last_update_date%type;

1727: MAXJRNL ic_jrnl_mst.journal_no%type;
1728: MINORGN ic_jrnl_mst.orgn_code%type;
1729: MAXORGN ic_jrnl_mst.orgn_code%type;
1730: MINMDATE ic_jrnl_mst.last_update_date%type;
1731: MAXMDATE ic_jrnl_mst.last_update_date%type;
1732: MINCDATE ic_jrnl_mst.creation_date%type;
1733: MAXCDATE ic_jrnl_mst.creation_date%type;
1734:
1735: no_of_unposted_rec number(10);

Line 1732: MINCDATE ic_jrnl_mst.creation_date%type;

1728: MINORGN ic_jrnl_mst.orgn_code%type;
1729: MAXORGN ic_jrnl_mst.orgn_code%type;
1730: MINMDATE ic_jrnl_mst.last_update_date%type;
1731: MAXMDATE ic_jrnl_mst.last_update_date%type;
1732: MINCDATE ic_jrnl_mst.creation_date%type;
1733: MAXCDATE ic_jrnl_mst.creation_date%type;
1734:
1735: no_of_unposted_rec number(10);
1736: posted varchar2(10):='F';

Line 1733: MAXCDATE ic_jrnl_mst.creation_date%type;

1729: MAXORGN ic_jrnl_mst.orgn_code%type;
1730: MINMDATE ic_jrnl_mst.last_update_date%type;
1731: MAXMDATE ic_jrnl_mst.last_update_date%type;
1732: MINCDATE ic_jrnl_mst.creation_date%type;
1733: MAXCDATE ic_jrnl_mst.creation_date%type;
1734:
1735: no_of_unposted_rec number(10);
1736: posted varchar2(10):='F';
1737: