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.CSZ_SERVICEREQUEST_UTIL_PVT dependencies on JTF_OBJECTS_B

Line 1303: FROM jtf_objects_b

1299: )IS SELECT select_id,
1300: select_details ,
1301: from_table ,
1302: where_clause
1303: FROM jtf_objects_b
1304: WHERE select_id is not null
1305: and select_details is not null
1306: and from_table is not null
1307: AND object_code = p_object_type;

Line 1309: l_select_id jtf_objects_b.select_id%TYPE;

1305: and select_details is not null
1306: and from_table is not null
1307: AND object_code = p_object_type;
1308:
1309: l_select_id jtf_objects_b.select_id%TYPE;
1310: l_select_details jtf_objects_b.select_details%TYPE;
1311: l_from_table jtf_objects_b.from_table%TYPE;
1312: l_where_clause jtf_objects_b.where_clause%TYPE;
1313: l_sql_statement VARCHAR2(3000);

Line 1310: l_select_details jtf_objects_b.select_details%TYPE;

1306: and from_table is not null
1307: AND object_code = p_object_type;
1308:
1309: l_select_id jtf_objects_b.select_id%TYPE;
1310: l_select_details jtf_objects_b.select_details%TYPE;
1311: l_from_table jtf_objects_b.from_table%TYPE;
1312: l_where_clause jtf_objects_b.where_clause%TYPE;
1313: l_sql_statement VARCHAR2(3000);
1314: l_details VARCHAR2(5000);

Line 1311: l_from_table jtf_objects_b.from_table%TYPE;

1307: AND object_code = p_object_type;
1308:
1309: l_select_id jtf_objects_b.select_id%TYPE;
1310: l_select_details jtf_objects_b.select_details%TYPE;
1311: l_from_table jtf_objects_b.from_table%TYPE;
1312: l_where_clause jtf_objects_b.where_clause%TYPE;
1313: l_sql_statement VARCHAR2(3000);
1314: l_details VARCHAR2(5000);
1315: l_select_id_alias jtf_objects_b.select_id%TYPE;

Line 1312: l_where_clause jtf_objects_b.where_clause%TYPE;

1308:
1309: l_select_id jtf_objects_b.select_id%TYPE;
1310: l_select_details jtf_objects_b.select_details%TYPE;
1311: l_from_table jtf_objects_b.from_table%TYPE;
1312: l_where_clause jtf_objects_b.where_clause%TYPE;
1313: l_sql_statement VARCHAR2(3000);
1314: l_details VARCHAR2(5000);
1315: l_select_id_alias jtf_objects_b.select_id%TYPE;
1316: l_select_id_value NUMBER;

Line 1315: l_select_id_alias jtf_objects_b.select_id%TYPE;

1311: l_from_table jtf_objects_b.from_table%TYPE;
1312: l_where_clause jtf_objects_b.where_clause%TYPE;
1313: l_sql_statement VARCHAR2(3000);
1314: l_details VARCHAR2(5000);
1315: l_select_id_alias jtf_objects_b.select_id%TYPE;
1316: l_select_id_value NUMBER;
1317: position NUMBER;
1318:
1319: type details_type is REF CURSOR;