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.

[Home] [Help]

APPS.GMA_PURGE_ENGINE dependencies on OP_ORDR_HDR

Line 1533: cursor c1(P_MINORDER op_ordr_hdr.order_no%type,

1529: select crit_tag,crit_value
1530: from sy_purg_mst_crit
1531: where purge_id=P_Purge_id;
1532:
1533: cursor c1(P_MINORDER op_ordr_hdr.order_no%type,
1534: P_MAXORDER op_ordr_hdr.order_no%type,
1535: P_MINORGN op_ordr_hdr.orgn_code%type,
1536: P_MAXORGN op_ordr_hdr.orgn_code%type,
1537: P_MINMDATE op_ordr_hdr.last_update_date%type,

Line 1534: P_MAXORDER op_ordr_hdr.order_no%type,

1530: from sy_purg_mst_crit
1531: where purge_id=P_Purge_id;
1532:
1533: cursor c1(P_MINORDER op_ordr_hdr.order_no%type,
1534: P_MAXORDER op_ordr_hdr.order_no%type,
1535: P_MINORGN op_ordr_hdr.orgn_code%type,
1536: P_MAXORGN op_ordr_hdr.orgn_code%type,
1537: P_MINMDATE op_ordr_hdr.last_update_date%type,
1538: P_MAXMDATE op_ordr_hdr.last_update_date%type,

Line 1535: P_MINORGN op_ordr_hdr.orgn_code%type,

1531: where purge_id=P_Purge_id;
1532:
1533: cursor c1(P_MINORDER op_ordr_hdr.order_no%type,
1534: P_MAXORDER op_ordr_hdr.order_no%type,
1535: P_MINORGN op_ordr_hdr.orgn_code%type,
1536: P_MAXORGN op_ordr_hdr.orgn_code%type,
1537: P_MINMDATE op_ordr_hdr.last_update_date%type,
1538: P_MAXMDATE op_ordr_hdr.last_update_date%type,
1539: P_MINCDATE op_ordr_hdr.creation_date%type,

Line 1536: P_MAXORGN op_ordr_hdr.orgn_code%type,

1532:
1533: cursor c1(P_MINORDER op_ordr_hdr.order_no%type,
1534: P_MAXORDER op_ordr_hdr.order_no%type,
1535: P_MINORGN op_ordr_hdr.orgn_code%type,
1536: P_MAXORGN op_ordr_hdr.orgn_code%type,
1537: P_MINMDATE op_ordr_hdr.last_update_date%type,
1538: P_MAXMDATE op_ordr_hdr.last_update_date%type,
1539: P_MINCDATE op_ordr_hdr.creation_date%type,
1540: P_MAXCDATE op_ordr_hdr.creation_date%type,

Line 1537: P_MINMDATE op_ordr_hdr.last_update_date%type,

1533: cursor c1(P_MINORDER op_ordr_hdr.order_no%type,
1534: P_MAXORDER op_ordr_hdr.order_no%type,
1535: P_MINORGN op_ordr_hdr.orgn_code%type,
1536: P_MAXORGN op_ordr_hdr.orgn_code%type,
1537: P_MINMDATE op_ordr_hdr.last_update_date%type,
1538: P_MAXMDATE op_ordr_hdr.last_update_date%type,
1539: P_MINCDATE op_ordr_hdr.creation_date%type,
1540: P_MAXCDATE op_ordr_hdr.creation_date%type,
1541: P_OSTATUS op_ordr_hdr.order_status%type)

Line 1538: P_MAXMDATE op_ordr_hdr.last_update_date%type,

1534: P_MAXORDER op_ordr_hdr.order_no%type,
1535: P_MINORGN op_ordr_hdr.orgn_code%type,
1536: P_MAXORGN op_ordr_hdr.orgn_code%type,
1537: P_MINMDATE op_ordr_hdr.last_update_date%type,
1538: P_MAXMDATE op_ordr_hdr.last_update_date%type,
1539: P_MINCDATE op_ordr_hdr.creation_date%type,
1540: P_MAXCDATE op_ordr_hdr.creation_date%type,
1541: P_OSTATUS op_ordr_hdr.order_status%type)
1542: is

Line 1539: P_MINCDATE op_ordr_hdr.creation_date%type,

1535: P_MINORGN op_ordr_hdr.orgn_code%type,
1536: P_MAXORGN op_ordr_hdr.orgn_code%type,
1537: P_MINMDATE op_ordr_hdr.last_update_date%type,
1538: P_MAXMDATE op_ordr_hdr.last_update_date%type,
1539: P_MINCDATE op_ordr_hdr.creation_date%type,
1540: P_MAXCDATE op_ordr_hdr.creation_date%type,
1541: P_OSTATUS op_ordr_hdr.order_status%type)
1542: is
1543: select distinct order_id

Line 1540: P_MAXCDATE op_ordr_hdr.creation_date%type,

1536: P_MAXORGN op_ordr_hdr.orgn_code%type,
1537: P_MINMDATE op_ordr_hdr.last_update_date%type,
1538: P_MAXMDATE op_ordr_hdr.last_update_date%type,
1539: P_MINCDATE op_ordr_hdr.creation_date%type,
1540: P_MAXCDATE op_ordr_hdr.creation_date%type,
1541: P_OSTATUS op_ordr_hdr.order_status%type)
1542: is
1543: select distinct order_id
1544: FROM op_ordr_hdr OH1

Line 1541: P_OSTATUS op_ordr_hdr.order_status%type)

1537: P_MINMDATE op_ordr_hdr.last_update_date%type,
1538: P_MAXMDATE op_ordr_hdr.last_update_date%type,
1539: P_MINCDATE op_ordr_hdr.creation_date%type,
1540: P_MAXCDATE op_ordr_hdr.creation_date%type,
1541: P_OSTATUS op_ordr_hdr.order_status%type)
1542: is
1543: select distinct order_id
1544: FROM op_ordr_hdr OH1
1545: WHERE order_no >= P_MINORDER

Line 1544: FROM op_ordr_hdr OH1

1540: P_MAXCDATE op_ordr_hdr.creation_date%type,
1541: P_OSTATUS op_ordr_hdr.order_status%type)
1542: is
1543: select distinct order_id
1544: FROM op_ordr_hdr OH1
1545: WHERE order_no >= P_MINORDER
1546: AND order_no <= P_MAXORDER
1547: AND orgn_code >= P_MINORGN
1548: AND orgn_code <= P_MAXORGN

Line 1579: MINORDER op_ordr_hdr.order_no%type;

1575: and doc_type = 'OPSO'
1576: and delete_mark=0
1577: and completed_ind =0;
1578:
1579: MINORDER op_ordr_hdr.order_no%type;
1580: MAXORDER op_ordr_hdr.order_no%type;
1581: MINORGN op_ordr_hdr.orgn_code%type;
1582: MAXORGN op_ordr_hdr.orgn_code%type;
1583: MINMDATE op_ordr_hdr.last_update_date%type;

Line 1580: MAXORDER op_ordr_hdr.order_no%type;

1576: and delete_mark=0
1577: and completed_ind =0;
1578:
1579: MINORDER op_ordr_hdr.order_no%type;
1580: MAXORDER op_ordr_hdr.order_no%type;
1581: MINORGN op_ordr_hdr.orgn_code%type;
1582: MAXORGN op_ordr_hdr.orgn_code%type;
1583: MINMDATE op_ordr_hdr.last_update_date%type;
1584: MAXMDATE op_ordr_hdr.last_update_date%type;

Line 1581: MINORGN op_ordr_hdr.orgn_code%type;

1577: and completed_ind =0;
1578:
1579: MINORDER op_ordr_hdr.order_no%type;
1580: MAXORDER op_ordr_hdr.order_no%type;
1581: MINORGN op_ordr_hdr.orgn_code%type;
1582: MAXORGN op_ordr_hdr.orgn_code%type;
1583: MINMDATE op_ordr_hdr.last_update_date%type;
1584: MAXMDATE op_ordr_hdr.last_update_date%type;
1585: MINCDATE op_ordr_hdr.creation_date%type;

Line 1582: MAXORGN op_ordr_hdr.orgn_code%type;

1578:
1579: MINORDER op_ordr_hdr.order_no%type;
1580: MAXORDER op_ordr_hdr.order_no%type;
1581: MINORGN op_ordr_hdr.orgn_code%type;
1582: MAXORGN op_ordr_hdr.orgn_code%type;
1583: MINMDATE op_ordr_hdr.last_update_date%type;
1584: MAXMDATE op_ordr_hdr.last_update_date%type;
1585: MINCDATE op_ordr_hdr.creation_date%type;
1586: MAXCDATE op_ordr_hdr.creation_date%type;

Line 1583: MINMDATE op_ordr_hdr.last_update_date%type;

1579: MINORDER op_ordr_hdr.order_no%type;
1580: MAXORDER op_ordr_hdr.order_no%type;
1581: MINORGN op_ordr_hdr.orgn_code%type;
1582: MAXORGN op_ordr_hdr.orgn_code%type;
1583: MINMDATE op_ordr_hdr.last_update_date%type;
1584: MAXMDATE op_ordr_hdr.last_update_date%type;
1585: MINCDATE op_ordr_hdr.creation_date%type;
1586: MAXCDATE op_ordr_hdr.creation_date%type;
1587: OSTATUS op_ordr_hdr.order_status%type;

Line 1584: MAXMDATE op_ordr_hdr.last_update_date%type;

1580: MAXORDER op_ordr_hdr.order_no%type;
1581: MINORGN op_ordr_hdr.orgn_code%type;
1582: MAXORGN op_ordr_hdr.orgn_code%type;
1583: MINMDATE op_ordr_hdr.last_update_date%type;
1584: MAXMDATE op_ordr_hdr.last_update_date%type;
1585: MINCDATE op_ordr_hdr.creation_date%type;
1586: MAXCDATE op_ordr_hdr.creation_date%type;
1587: OSTATUS op_ordr_hdr.order_status%type;
1588:

Line 1585: MINCDATE op_ordr_hdr.creation_date%type;

1581: MINORGN op_ordr_hdr.orgn_code%type;
1582: MAXORGN op_ordr_hdr.orgn_code%type;
1583: MINMDATE op_ordr_hdr.last_update_date%type;
1584: MAXMDATE op_ordr_hdr.last_update_date%type;
1585: MINCDATE op_ordr_hdr.creation_date%type;
1586: MAXCDATE op_ordr_hdr.creation_date%type;
1587: OSTATUS op_ordr_hdr.order_status%type;
1588:
1589: no_of_unposted_rec number(10):=0;

Line 1586: MAXCDATE op_ordr_hdr.creation_date%type;

1582: MAXORGN op_ordr_hdr.orgn_code%type;
1583: MINMDATE op_ordr_hdr.last_update_date%type;
1584: MAXMDATE op_ordr_hdr.last_update_date%type;
1585: MINCDATE op_ordr_hdr.creation_date%type;
1586: MAXCDATE op_ordr_hdr.creation_date%type;
1587: OSTATUS op_ordr_hdr.order_status%type;
1588:
1589: no_of_unposted_rec number(10):=0;
1590: posted varchar2(10):='F';

Line 1587: OSTATUS op_ordr_hdr.order_status%type;

1583: MINMDATE op_ordr_hdr.last_update_date%type;
1584: MAXMDATE op_ordr_hdr.last_update_date%type;
1585: MINCDATE op_ordr_hdr.creation_date%type;
1586: MAXCDATE op_ordr_hdr.creation_date%type;
1587: OSTATUS op_ordr_hdr.order_status%type;
1588:
1589: no_of_unposted_rec number(10):=0;
1590: posted varchar2(10):='F';
1591: