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_LIST_SRC_FIELD_PVT dependencies on AMS_LIST_SRC_FIELDS_VL

Line 953: FROM ams_list_src_fields_vl

949: IS
950:
951: CURSOR c_lstsrcfld_crt IS
952: SELECT *
953: FROM ams_list_src_fields_vl
954: WHERE list_source_type_id=p_list_src_field_rec.list_source_type_id
955: and source_column_name = p_list_src_field_rec.source_column_name;
956:
957: CURSOR c_lstsrcfld_upd IS

Line 959: FROM ams_list_src_fields_vl

955: and source_column_name = p_list_src_field_rec.source_column_name;
956:
957: CURSOR c_lstsrcfld_upd IS
958: SELECT *
959: FROM ams_list_src_fields_vl
960: WHERE list_source_type_id=p_list_src_field_rec.list_source_type_id
961: and source_column_name = p_list_src_field_rec.source_column_name
962: and list_source_field_id <> p_list_src_field_rec.list_source_field_id;
963:

Line 967: -- FROM ams_list_src_fields_vl

963:
964: CURSOR c_fldcolname_crt IS
965: -- Bug 3664542, SOLIN SQL Repository, tuning
966: -- SELECT *
967: -- FROM ams_list_src_fields_vl
968: -- WHERE
969: -- (list_source_type_id=p_list_src_field_rec.list_source_type_id
970: -- OR list_source_type_id IN
971: -- ( SELECT sub_source_type_id

Line 980: FROM ams_list_src_fields_vl

976: -- )
977: -- )
978: -- AND field_column_name = p_list_src_field_rec.field_column_name;
979: SELECT *
980: FROM ams_list_src_fields_vl
981: WHERE list_source_type_id=p_list_src_field_rec.list_source_type_id
982: AND field_column_name = p_list_src_field_rec.field_column_name
983: UNION ALL
984: SELECT *

Line 985: FROM ams_list_src_fields_vl

981: WHERE list_source_type_id=p_list_src_field_rec.list_source_type_id
982: AND field_column_name = p_list_src_field_rec.field_column_name
983: UNION ALL
984: SELECT *
985: FROM ams_list_src_fields_vl
986: WHERE list_source_type_id IN
987: ( SELECT sub_source_type_id
988: FROM ams_list_src_type_assocs
989: WHERE ( master_source_type_id = p_list_src_field_rec.list_source_type_id

Line 998: -- FROM ams_list_src_fields_vl

994:
995: CURSOR c_fldcolname_upd IS
996: -- Bug 3664542, SOLIN SQL Repository, tuning
997: -- SELECT *
998: -- FROM ams_list_src_fields_vl
999: -- WHERE
1000: -- (list_source_type_id=p_list_src_field_rec.list_source_type_id
1001: -- OR list_source_type_id IN
1002: -- ( SELECT sub_source_type_id

Line 1012: FROM ams_list_src_fields_vl

1008: -- )
1009: -- AND field_column_name = p_list_src_field_rec.field_column_name
1010: -- AND list_source_field_id <> p_list_src_field_rec.list_source_field_id;
1011: SELECT *
1012: FROM ams_list_src_fields_vl
1013: WHERE list_source_type_id=p_list_src_field_rec.list_source_type_id
1014: AND field_column_name = p_list_src_field_rec.field_column_name
1015: AND list_source_field_id <> p_list_src_field_rec.list_source_field_id
1016: UNION ALL

Line 1018: FROM ams_list_src_fields_vl

1014: AND field_column_name = p_list_src_field_rec.field_column_name
1015: AND list_source_field_id <> p_list_src_field_rec.list_source_field_id
1016: UNION ALL
1017: SELECT *
1018: FROM ams_list_src_fields_vl
1019: WHERE list_source_type_id IN
1020: ( SELECT sub_source_type_id
1021: FROM ams_list_src_type_assocs
1022: WHERE ( master_source_type_id = p_list_src_field_rec.list_source_type_id

Line 1177: FROM ams_list_src_fields_vl

1173: l_return_status VARCHAR2(1);
1174:
1175: CURSOR c_complete IS
1176: SELECT *
1177: FROM ams_list_src_fields_vl
1178: WHERE list_source_field_id = p_list_src_field_rec.list_source_field_id;
1179: l_list_src_field_rec c_complete%ROWTYPE;
1180: BEGIN
1181: x_complete_rec := p_list_src_field_rec;