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 PO_ORDR_HDR

Line 2025: cursor c1(P_MINPO po_ordr_hdr.po_no%type,

2021: select crit_tag,crit_value
2022: from sy_purg_mst_crit
2023: where purge_id=P_Purge_id;
2024:
2025: cursor c1(P_MINPO po_ordr_hdr.po_no%type,
2026: P_MAXPO po_ordr_hdr.po_no%type,
2027: P_MINORGN po_ordr_hdr.orgn_code%type,
2028: P_MAXORGN po_ordr_hdr.orgn_code%type,
2029: P_MINMDATE po_ordr_hdr.last_update_date%type,

Line 2026: P_MAXPO po_ordr_hdr.po_no%type,

2022: from sy_purg_mst_crit
2023: where purge_id=P_Purge_id;
2024:
2025: cursor c1(P_MINPO po_ordr_hdr.po_no%type,
2026: P_MAXPO po_ordr_hdr.po_no%type,
2027: P_MINORGN po_ordr_hdr.orgn_code%type,
2028: P_MAXORGN po_ordr_hdr.orgn_code%type,
2029: P_MINMDATE po_ordr_hdr.last_update_date%type,
2030: P_MAXMDATE po_ordr_hdr.last_update_date%type,

Line 2027: P_MINORGN po_ordr_hdr.orgn_code%type,

2023: where purge_id=P_Purge_id;
2024:
2025: cursor c1(P_MINPO po_ordr_hdr.po_no%type,
2026: P_MAXPO po_ordr_hdr.po_no%type,
2027: P_MINORGN po_ordr_hdr.orgn_code%type,
2028: P_MAXORGN po_ordr_hdr.orgn_code%type,
2029: P_MINMDATE po_ordr_hdr.last_update_date%type,
2030: P_MAXMDATE po_ordr_hdr.last_update_date%type,
2031: P_MINCDATE po_ordr_hdr.creation_date%type,

Line 2028: P_MAXORGN po_ordr_hdr.orgn_code%type,

2024:
2025: cursor c1(P_MINPO po_ordr_hdr.po_no%type,
2026: P_MAXPO po_ordr_hdr.po_no%type,
2027: P_MINORGN po_ordr_hdr.orgn_code%type,
2028: P_MAXORGN po_ordr_hdr.orgn_code%type,
2029: P_MINMDATE po_ordr_hdr.last_update_date%type,
2030: P_MAXMDATE po_ordr_hdr.last_update_date%type,
2031: P_MINCDATE po_ordr_hdr.creation_date%type,
2032: P_MAXCDATE po_ordr_hdr.creation_date%type)

Line 2029: P_MINMDATE po_ordr_hdr.last_update_date%type,

2025: cursor c1(P_MINPO po_ordr_hdr.po_no%type,
2026: P_MAXPO po_ordr_hdr.po_no%type,
2027: P_MINORGN po_ordr_hdr.orgn_code%type,
2028: P_MAXORGN po_ordr_hdr.orgn_code%type,
2029: P_MINMDATE po_ordr_hdr.last_update_date%type,
2030: P_MAXMDATE po_ordr_hdr.last_update_date%type,
2031: P_MINCDATE po_ordr_hdr.creation_date%type,
2032: P_MAXCDATE po_ordr_hdr.creation_date%type)
2033: is

Line 2030: P_MAXMDATE po_ordr_hdr.last_update_date%type,

2026: P_MAXPO po_ordr_hdr.po_no%type,
2027: P_MINORGN po_ordr_hdr.orgn_code%type,
2028: P_MAXORGN po_ordr_hdr.orgn_code%type,
2029: P_MINMDATE po_ordr_hdr.last_update_date%type,
2030: P_MAXMDATE po_ordr_hdr.last_update_date%type,
2031: P_MINCDATE po_ordr_hdr.creation_date%type,
2032: P_MAXCDATE po_ordr_hdr.creation_date%type)
2033: is
2034: select distinct PH2.po_id

Line 2031: P_MINCDATE po_ordr_hdr.creation_date%type,

2027: P_MINORGN po_ordr_hdr.orgn_code%type,
2028: P_MAXORGN po_ordr_hdr.orgn_code%type,
2029: P_MINMDATE po_ordr_hdr.last_update_date%type,
2030: P_MAXMDATE po_ordr_hdr.last_update_date%type,
2031: P_MINCDATE po_ordr_hdr.creation_date%type,
2032: P_MAXCDATE po_ordr_hdr.creation_date%type)
2033: is
2034: select distinct PH2.po_id
2035: FROM po_ordr_hdr PH2

Line 2032: P_MAXCDATE po_ordr_hdr.creation_date%type)

2028: P_MAXORGN po_ordr_hdr.orgn_code%type,
2029: P_MINMDATE po_ordr_hdr.last_update_date%type,
2030: P_MAXMDATE po_ordr_hdr.last_update_date%type,
2031: P_MINCDATE po_ordr_hdr.creation_date%type,
2032: P_MAXCDATE po_ordr_hdr.creation_date%type)
2033: is
2034: select distinct PH2.po_id
2035: FROM po_ordr_hdr PH2
2036: WHERE PH2.po_no >= P_MINPO

Line 2035: FROM po_ordr_hdr PH2

2031: P_MINCDATE po_ordr_hdr.creation_date%type,
2032: P_MAXCDATE po_ordr_hdr.creation_date%type)
2033: is
2034: select distinct PH2.po_id
2035: FROM po_ordr_hdr PH2
2036: WHERE PH2.po_no >= P_MINPO
2037: AND PH2.po_no <= P_MAXPO
2038: AND PH2.orgn_code >= P_MINORGN
2039: AND PH2.orgn_code <= P_MAXORGN

Line 2058: MINPO po_ordr_hdr.po_no%type;

2054: where po_id = ppo_id
2055: and RECV_LINE_ID not in (SELECT RECV_LINE_ID from po_recv_hst where po_id=ppo_id and delete_mark=1)
2056: and gl_posted_ind <> 1;
2057:
2058: MINPO po_ordr_hdr.po_no%type;
2059: MAXPO po_ordr_hdr.po_no%type;
2060: MINORGN po_ordr_hdr.orgn_code%type;
2061: MAXORGN po_ordr_hdr.orgn_code%type;
2062: MINMDATE po_ordr_hdr.last_update_date%type;

Line 2059: MAXPO po_ordr_hdr.po_no%type;

2055: and RECV_LINE_ID not in (SELECT RECV_LINE_ID from po_recv_hst where po_id=ppo_id and delete_mark=1)
2056: and gl_posted_ind <> 1;
2057:
2058: MINPO po_ordr_hdr.po_no%type;
2059: MAXPO po_ordr_hdr.po_no%type;
2060: MINORGN po_ordr_hdr.orgn_code%type;
2061: MAXORGN po_ordr_hdr.orgn_code%type;
2062: MINMDATE po_ordr_hdr.last_update_date%type;
2063: MAXMDATE po_ordr_hdr.last_update_date%type;

Line 2060: MINORGN po_ordr_hdr.orgn_code%type;

2056: and gl_posted_ind <> 1;
2057:
2058: MINPO po_ordr_hdr.po_no%type;
2059: MAXPO po_ordr_hdr.po_no%type;
2060: MINORGN po_ordr_hdr.orgn_code%type;
2061: MAXORGN po_ordr_hdr.orgn_code%type;
2062: MINMDATE po_ordr_hdr.last_update_date%type;
2063: MAXMDATE po_ordr_hdr.last_update_date%type;
2064: MINCDATE po_ordr_hdr.creation_date%type;

Line 2061: MAXORGN po_ordr_hdr.orgn_code%type;

2057:
2058: MINPO po_ordr_hdr.po_no%type;
2059: MAXPO po_ordr_hdr.po_no%type;
2060: MINORGN po_ordr_hdr.orgn_code%type;
2061: MAXORGN po_ordr_hdr.orgn_code%type;
2062: MINMDATE po_ordr_hdr.last_update_date%type;
2063: MAXMDATE po_ordr_hdr.last_update_date%type;
2064: MINCDATE po_ordr_hdr.creation_date%type;
2065: MAXCDATE po_ordr_hdr.creation_date%type;

Line 2062: MINMDATE po_ordr_hdr.last_update_date%type;

2058: MINPO po_ordr_hdr.po_no%type;
2059: MAXPO po_ordr_hdr.po_no%type;
2060: MINORGN po_ordr_hdr.orgn_code%type;
2061: MAXORGN po_ordr_hdr.orgn_code%type;
2062: MINMDATE po_ordr_hdr.last_update_date%type;
2063: MAXMDATE po_ordr_hdr.last_update_date%type;
2064: MINCDATE po_ordr_hdr.creation_date%type;
2065: MAXCDATE po_ordr_hdr.creation_date%type;
2066:

Line 2063: MAXMDATE po_ordr_hdr.last_update_date%type;

2059: MAXPO po_ordr_hdr.po_no%type;
2060: MINORGN po_ordr_hdr.orgn_code%type;
2061: MAXORGN po_ordr_hdr.orgn_code%type;
2062: MINMDATE po_ordr_hdr.last_update_date%type;
2063: MAXMDATE po_ordr_hdr.last_update_date%type;
2064: MINCDATE po_ordr_hdr.creation_date%type;
2065: MAXCDATE po_ordr_hdr.creation_date%type;
2066:
2067: no_of_unposted_rec number(10):=0;

Line 2064: MINCDATE po_ordr_hdr.creation_date%type;

2060: MINORGN po_ordr_hdr.orgn_code%type;
2061: MAXORGN po_ordr_hdr.orgn_code%type;
2062: MINMDATE po_ordr_hdr.last_update_date%type;
2063: MAXMDATE po_ordr_hdr.last_update_date%type;
2064: MINCDATE po_ordr_hdr.creation_date%type;
2065: MAXCDATE po_ordr_hdr.creation_date%type;
2066:
2067: no_of_unposted_rec number(10):=0;
2068: posted varchar2(10):='F';

Line 2065: MAXCDATE po_ordr_hdr.creation_date%type;

2061: MAXORGN po_ordr_hdr.orgn_code%type;
2062: MINMDATE po_ordr_hdr.last_update_date%type;
2063: MAXMDATE po_ordr_hdr.last_update_date%type;
2064: MINCDATE po_ordr_hdr.creation_date%type;
2065: MAXCDATE po_ordr_hdr.creation_date%type;
2066:
2067: no_of_unposted_rec number(10):=0;
2068: posted varchar2(10):='F';
2069: