DBA Data[Home] [Help]

APPS.JTF_TASK_UTL_EXT dependencies on JTF_OBJECTS_B

Line 779: FROM jtf_objects_b

775: RETURN VARCHAR2
776: IS
777: CURSOR c_object IS
778: SELECT select_id, select_details, from_table, where_clause
779: FROM jtf_objects_b
780: WHERE object_code = p_object_code;
781:
782: l_id_column jtf_objects_b.select_id%TYPE;
783: l_detail_column jtf_objects_b.select_details%TYPE;

Line 782: l_id_column jtf_objects_b.select_id%TYPE;

778: SELECT select_id, select_details, from_table, where_clause
779: FROM jtf_objects_b
780: WHERE object_code = p_object_code;
781:
782: l_id_column jtf_objects_b.select_id%TYPE;
783: l_detail_column jtf_objects_b.select_details%TYPE;
784: l_from_clause jtf_objects_b.from_table%TYPE;
785: l_where_clause jtf_objects_b.where_clause%TYPE;
786:

Line 783: l_detail_column jtf_objects_b.select_details%TYPE;

779: FROM jtf_objects_b
780: WHERE object_code = p_object_code;
781:
782: l_id_column jtf_objects_b.select_id%TYPE;
783: l_detail_column jtf_objects_b.select_details%TYPE;
784: l_from_clause jtf_objects_b.from_table%TYPE;
785: l_where_clause jtf_objects_b.where_clause%TYPE;
786:
787: l_object_details VARCHAR2(2000);

Line 784: l_from_clause jtf_objects_b.from_table%TYPE;

780: WHERE object_code = p_object_code;
781:
782: l_id_column jtf_objects_b.select_id%TYPE;
783: l_detail_column jtf_objects_b.select_details%TYPE;
784: l_from_clause jtf_objects_b.from_table%TYPE;
785: l_where_clause jtf_objects_b.where_clause%TYPE;
786:
787: l_object_details VARCHAR2(2000);
788: sql_stmt VARCHAR2(2000);

Line 785: l_where_clause jtf_objects_b.where_clause%TYPE;

781:
782: l_id_column jtf_objects_b.select_id%TYPE;
783: l_detail_column jtf_objects_b.select_details%TYPE;
784: l_from_clause jtf_objects_b.from_table%TYPE;
785: l_where_clause jtf_objects_b.where_clause%TYPE;
786:
787: l_object_details VARCHAR2(2000);
788: sql_stmt VARCHAR2(2000);
789: BEGIN