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 GME_BATCH_HEADER

Line 1830: cursor c1(P_MINBATCH gme_batch_header.batch_no%type,

1826: select crit_tag,crit_value
1827: from sy_purg_mst_crit
1828: where purge_id=P_Purge_id;
1829:
1830: cursor c1(P_MINBATCH gme_batch_header.batch_no%type,
1831: P_MAXBATCH gme_batch_header.batch_no%type,
1832: P_MINPLANT gme_batch_header.plant_code%type,
1833: P_MAXPLANT gme_batch_header.plant_code%type,
1834: P_MINMDATE gme_batch_header.last_update_date%type,

Line 1831: P_MAXBATCH gme_batch_header.batch_no%type,

1827: from sy_purg_mst_crit
1828: where purge_id=P_Purge_id;
1829:
1830: cursor c1(P_MINBATCH gme_batch_header.batch_no%type,
1831: P_MAXBATCH gme_batch_header.batch_no%type,
1832: P_MINPLANT gme_batch_header.plant_code%type,
1833: P_MAXPLANT gme_batch_header.plant_code%type,
1834: P_MINMDATE gme_batch_header.last_update_date%type,
1835: P_MAXMDATE gme_batch_header.last_update_date%type,

Line 1832: P_MINPLANT gme_batch_header.plant_code%type,

1828: where purge_id=P_Purge_id;
1829:
1830: cursor c1(P_MINBATCH gme_batch_header.batch_no%type,
1831: P_MAXBATCH gme_batch_header.batch_no%type,
1832: P_MINPLANT gme_batch_header.plant_code%type,
1833: P_MAXPLANT gme_batch_header.plant_code%type,
1834: P_MINMDATE gme_batch_header.last_update_date%type,
1835: P_MAXMDATE gme_batch_header.last_update_date%type,
1836: P_MINCDATE gme_batch_header.creation_date%type,

Line 1833: P_MAXPLANT gme_batch_header.plant_code%type,

1829:
1830: cursor c1(P_MINBATCH gme_batch_header.batch_no%type,
1831: P_MAXBATCH gme_batch_header.batch_no%type,
1832: P_MINPLANT gme_batch_header.plant_code%type,
1833: P_MAXPLANT gme_batch_header.plant_code%type,
1834: P_MINMDATE gme_batch_header.last_update_date%type,
1835: P_MAXMDATE gme_batch_header.last_update_date%type,
1836: P_MINCDATE gme_batch_header.creation_date%type,
1837: P_MAXCDATE gme_batch_header.creation_date%type,

Line 1834: P_MINMDATE gme_batch_header.last_update_date%type,

1830: cursor c1(P_MINBATCH gme_batch_header.batch_no%type,
1831: P_MAXBATCH gme_batch_header.batch_no%type,
1832: P_MINPLANT gme_batch_header.plant_code%type,
1833: P_MAXPLANT gme_batch_header.plant_code%type,
1834: P_MINMDATE gme_batch_header.last_update_date%type,
1835: P_MAXMDATE gme_batch_header.last_update_date%type,
1836: P_MINCDATE gme_batch_header.creation_date%type,
1837: P_MAXCDATE gme_batch_header.creation_date%type,
1838: P_PSTATUS gme_batch_header.batch_status%type)

Line 1835: P_MAXMDATE gme_batch_header.last_update_date%type,

1831: P_MAXBATCH gme_batch_header.batch_no%type,
1832: P_MINPLANT gme_batch_header.plant_code%type,
1833: P_MAXPLANT gme_batch_header.plant_code%type,
1834: P_MINMDATE gme_batch_header.last_update_date%type,
1835: P_MAXMDATE gme_batch_header.last_update_date%type,
1836: P_MINCDATE gme_batch_header.creation_date%type,
1837: P_MAXCDATE gme_batch_header.creation_date%type,
1838: P_PSTATUS gme_batch_header.batch_status%type)
1839: is

Line 1836: P_MINCDATE gme_batch_header.creation_date%type,

1832: P_MINPLANT gme_batch_header.plant_code%type,
1833: P_MAXPLANT gme_batch_header.plant_code%type,
1834: P_MINMDATE gme_batch_header.last_update_date%type,
1835: P_MAXMDATE gme_batch_header.last_update_date%type,
1836: P_MINCDATE gme_batch_header.creation_date%type,
1837: P_MAXCDATE gme_batch_header.creation_date%type,
1838: P_PSTATUS gme_batch_header.batch_status%type)
1839: is
1840: select distinct BH2.batch_id

Line 1837: P_MAXCDATE gme_batch_header.creation_date%type,

1833: P_MAXPLANT gme_batch_header.plant_code%type,
1834: P_MINMDATE gme_batch_header.last_update_date%type,
1835: P_MAXMDATE gme_batch_header.last_update_date%type,
1836: P_MINCDATE gme_batch_header.creation_date%type,
1837: P_MAXCDATE gme_batch_header.creation_date%type,
1838: P_PSTATUS gme_batch_header.batch_status%type)
1839: is
1840: select distinct BH2.batch_id
1841: FROM gme_batch_header BH2

Line 1838: P_PSTATUS gme_batch_header.batch_status%type)

1834: P_MINMDATE gme_batch_header.last_update_date%type,
1835: P_MAXMDATE gme_batch_header.last_update_date%type,
1836: P_MINCDATE gme_batch_header.creation_date%type,
1837: P_MAXCDATE gme_batch_header.creation_date%type,
1838: P_PSTATUS gme_batch_header.batch_status%type)
1839: is
1840: select distinct BH2.batch_id
1841: FROM gme_batch_header BH2
1842: WHERE BH2.batch_no >= P_MINBATCH

Line 1841: FROM gme_batch_header BH2

1837: P_MAXCDATE gme_batch_header.creation_date%type,
1838: P_PSTATUS gme_batch_header.batch_status%type)
1839: is
1840: select distinct BH2.batch_id
1841: FROM gme_batch_header BH2
1842: WHERE BH2.batch_no >= P_MINBATCH
1843: AND BH2.batch_no <= P_MAXBATCH
1844: AND BH2.plant_code >= P_MINPLANT
1845: AND BH2.plant_code <= P_MAXPLANT

Line 1853: cursor cur_regular_or_phantom(P_batch_id GME_BATCH_HEADER.batch_id%type) is

1849: AND BH2.creation_date <= P_MAXCDATE
1850: AND BH2.batch_status = P_PSTATUS
1851: AND (BH2.batch_status = -1 or BH2.batch_status = -3 or BH2.batch_status = 4);
1852:
1853: cursor cur_regular_or_phantom(P_batch_id GME_BATCH_HEADER.batch_id%type) is
1854: SELECT batch_id,parentline_id
1855: FROM gme_batch_header
1856: WHERE batch_id=P_batch_id;
1857:

Line 1855: FROM gme_batch_header

1851: AND (BH2.batch_status = -1 or BH2.batch_status = -3 or BH2.batch_status = 4);
1852:
1853: cursor cur_regular_or_phantom(P_batch_id GME_BATCH_HEADER.batch_id%type) is
1854: SELECT batch_id,parentline_id
1855: FROM gme_batch_header
1856: WHERE batch_id=P_batch_id;
1857:
1858: cursor cur_phantoms(p_batch_id GME_BATCH_HEADER.batch_id%type) is
1859: select batch_id,batch_status,gl_posted_ind,update_inventory_ind

Line 1858: cursor cur_phantoms(p_batch_id GME_BATCH_HEADER.batch_id%type) is

1854: SELECT batch_id,parentline_id
1855: FROM gme_batch_header
1856: WHERE batch_id=P_batch_id;
1857:
1858: cursor cur_phantoms(p_batch_id GME_BATCH_HEADER.batch_id%type) is
1859: select batch_id,batch_status,gl_posted_ind,update_inventory_ind
1860: FROM GME_BATCH_HEADER
1861: WHERE batch_id IN (SELECT DISTINCT batch_id
1862: FROM gme_material_details

Line 1860: FROM GME_BATCH_HEADER

1856: WHERE batch_id=P_batch_id;
1857:
1858: cursor cur_phantoms(p_batch_id GME_BATCH_HEADER.batch_id%type) is
1859: select batch_id,batch_status,gl_posted_ind,update_inventory_ind
1860: FROM GME_BATCH_HEADER
1861: WHERE batch_id IN (SELECT DISTINCT batch_id
1862: FROM gme_material_details
1863: START WITH batch_id=P_batch_id
1864: CONNECT BY batch_id = PRIOR phantom_id);

Line 1868: MINBATCH gme_batch_header.batch_no%type;

1864: CONNECT BY batch_id = PRIOR phantom_id);
1865: -- AND GL_POSTED_IND<>1
1866: -- AND BATCH_STATUS not in( -1,-3);
1867:
1868: MINBATCH gme_batch_header.batch_no%type;
1869: MAXBATCH gme_batch_header.batch_no%type;
1870: MINPLANT gme_batch_header.plant_code%type;
1871: MAXPLANT gme_batch_header.plant_code%type;
1872: MINMDATE gme_batch_header.last_update_date%type;

Line 1869: MAXBATCH gme_batch_header.batch_no%type;

1865: -- AND GL_POSTED_IND<>1
1866: -- AND BATCH_STATUS not in( -1,-3);
1867:
1868: MINBATCH gme_batch_header.batch_no%type;
1869: MAXBATCH gme_batch_header.batch_no%type;
1870: MINPLANT gme_batch_header.plant_code%type;
1871: MAXPLANT gme_batch_header.plant_code%type;
1872: MINMDATE gme_batch_header.last_update_date%type;
1873: MAXMDATE gme_batch_header.last_update_date%type;

Line 1870: MINPLANT gme_batch_header.plant_code%type;

1866: -- AND BATCH_STATUS not in( -1,-3);
1867:
1868: MINBATCH gme_batch_header.batch_no%type;
1869: MAXBATCH gme_batch_header.batch_no%type;
1870: MINPLANT gme_batch_header.plant_code%type;
1871: MAXPLANT gme_batch_header.plant_code%type;
1872: MINMDATE gme_batch_header.last_update_date%type;
1873: MAXMDATE gme_batch_header.last_update_date%type;
1874: MINCDATE gme_batch_header.creation_date%type;

Line 1871: MAXPLANT gme_batch_header.plant_code%type;

1867:
1868: MINBATCH gme_batch_header.batch_no%type;
1869: MAXBATCH gme_batch_header.batch_no%type;
1870: MINPLANT gme_batch_header.plant_code%type;
1871: MAXPLANT gme_batch_header.plant_code%type;
1872: MINMDATE gme_batch_header.last_update_date%type;
1873: MAXMDATE gme_batch_header.last_update_date%type;
1874: MINCDATE gme_batch_header.creation_date%type;
1875: MAXCDATE gme_batch_header.creation_date%type;

Line 1872: MINMDATE gme_batch_header.last_update_date%type;

1868: MINBATCH gme_batch_header.batch_no%type;
1869: MAXBATCH gme_batch_header.batch_no%type;
1870: MINPLANT gme_batch_header.plant_code%type;
1871: MAXPLANT gme_batch_header.plant_code%type;
1872: MINMDATE gme_batch_header.last_update_date%type;
1873: MAXMDATE gme_batch_header.last_update_date%type;
1874: MINCDATE gme_batch_header.creation_date%type;
1875: MAXCDATE gme_batch_header.creation_date%type;
1876: PSTATUS gme_batch_header.batch_status%type;

Line 1873: MAXMDATE gme_batch_header.last_update_date%type;

1869: MAXBATCH gme_batch_header.batch_no%type;
1870: MINPLANT gme_batch_header.plant_code%type;
1871: MAXPLANT gme_batch_header.plant_code%type;
1872: MINMDATE gme_batch_header.last_update_date%type;
1873: MAXMDATE gme_batch_header.last_update_date%type;
1874: MINCDATE gme_batch_header.creation_date%type;
1875: MAXCDATE gme_batch_header.creation_date%type;
1876: PSTATUS gme_batch_header.batch_status%type;
1877:

Line 1874: MINCDATE gme_batch_header.creation_date%type;

1870: MINPLANT gme_batch_header.plant_code%type;
1871: MAXPLANT gme_batch_header.plant_code%type;
1872: MINMDATE gme_batch_header.last_update_date%type;
1873: MAXMDATE gme_batch_header.last_update_date%type;
1874: MINCDATE gme_batch_header.creation_date%type;
1875: MAXCDATE gme_batch_header.creation_date%type;
1876: PSTATUS gme_batch_header.batch_status%type;
1877:
1878: tmp_cur_rphantom cur_regular_or_phantom%rowtype;

Line 1875: MAXCDATE gme_batch_header.creation_date%type;

1871: MAXPLANT gme_batch_header.plant_code%type;
1872: MINMDATE gme_batch_header.last_update_date%type;
1873: MAXMDATE gme_batch_header.last_update_date%type;
1874: MINCDATE gme_batch_header.creation_date%type;
1875: MAXCDATE gme_batch_header.creation_date%type;
1876: PSTATUS gme_batch_header.batch_status%type;
1877:
1878: tmp_cur_rphantom cur_regular_or_phantom%rowtype;
1879:

Line 1876: PSTATUS gme_batch_header.batch_status%type;

1872: MINMDATE gme_batch_header.last_update_date%type;
1873: MAXMDATE gme_batch_header.last_update_date%type;
1874: MINCDATE gme_batch_header.creation_date%type;
1875: MAXCDATE gme_batch_header.creation_date%type;
1876: PSTATUS gme_batch_header.batch_status%type;
1877:
1878: tmp_cur_rphantom cur_regular_or_phantom%rowtype;
1879:
1880: no_of_unposted_rec number(10);