DBA Data[Home] [Help]

APPS.GMA_PURGE_ENGINE dependencies on SY_PURG_MST_CRIT

Line 640: FROM sy_purg_mst_crit MC

636: SELECT DC.crit_tag crit_tag
637: , REPLACE(NVL(DC.value_mask,'{X}'),
638: '{X}',
639: NVL(MC.crit_value,DC.default_value)) value
640: FROM sy_purg_mst_crit MC
641: , sy_purg_def_crit DC
642: , sy_purg_mst MS
643: WHERE MC.crit_tag = DC.crit_tag
644: AND MC.purge_id = MS.purge_id

Line 1530: from sy_purg_mst_crit

1526: RETURN LONG
1527: is
1528: cursor purge_crit is
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,

Line 1686: from sy_purg_mst_crit

1682: RETURN LONG
1683: is
1684: cursor purge_crit is
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,

Line 1827: from sy_purg_mst_crit

1823: --Ignore GL_POSTED_IND for UPDATE_INVENTORY_IND flag is set to off 'Y' and purge.
1824:
1825: cursor purge_crit is
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,

Line 2022: from sy_purg_mst_crit

2018:
2019: is
2020: cursor purge_crit is
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,