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.AMS_PARTY_MKT_SEG_LOADER_PVT dependencies on AMS_DISCOVERER_SQL

Line 1353: -- SELECT sql_string FROM AMS_DISCOVERER_SQL

1349: WHERE act_discoverer_used_by_id = cell_id
1350: AND arc_act_discoverer_used_by = 'CELL';
1351:
1352: -- CURSOR c_sql_str(WB_NAME IN VARCHAR2,WB_OWNER IN VARCHAR2) IS
1353: -- SELECT sql_string FROM AMS_DISCOVERER_SQL
1354: -- WHERE workbook_name = wb_name
1355: -- AND workbook_owner_name = wb_owner ;
1356:
1357: BEGIN

Line 1712: FROM ams_discoverer_sql

1708:
1709: -- Define the cursor to find the first worksheet
1710: CURSOR c_ws_name IS
1711: SELECT 1
1712: FROM ams_discoverer_sql
1713: WHERE workbook_name = p_workbook_name
1714: AND workbook_owner_name = p_workbook_owner
1715: AND worksheet_name = p_worksheet_name ;
1716:

Line 1720: FROM ams_discoverer_sql

1716:
1717: -- Define the cursor to get the sql between SELECT and first Party ID
1718: CURSOR c_till_from_sql(l_sequence_order NUMBER ) IS
1719: SELECT sql_string
1720: FROM ams_discoverer_sql
1721: WHERE workbook_name = p_workbook_name
1722: AND worksheet_name = p_worksheet_name
1723: AND workbook_owner_name = p_workbook_owner
1724: AND sequence_order <= l_sequence_order

Line 1730: FROM ams_discoverer_sql

1726:
1727: -- Define the cursor to get the sql string after from
1728: CURSOR c_sql_str(l_sequence_order NUMBER ) IS
1729: SELECT sql_string
1730: FROM ams_discoverer_sql
1731: WHERE workbook_name = p_workbook_name
1732: AND worksheet_name = p_worksheet_name
1733: AND workbook_owner_name = p_workbook_owner
1734: AND sequence_order >= l_sequence_order