APPS.AMS_LIST_SRC_FIELD_PVT dependencies on AMS_LIST_SRC_FIELDS_VL

Line 984: FROM ams_list_src_fields_vl

980: IS
981:
982: CURSOR c_lstsrcfld_crt IS
983: SELECT *
984: FROM ams_list_src_fields_vl
985: WHERE list_source_type_id=p_list_src_field_rec.list_source_type_id
986: and source_column_name = p_list_src_field_rec.source_column_name;
987:
988: CURSOR c_lstsrcfld_upd IS

Line 990: FROM ams_list_src_fields_vl

986: and source_column_name = p_list_src_field_rec.source_column_name;
987:
988: CURSOR c_lstsrcfld_upd IS
989: SELECT *
990: FROM ams_list_src_fields_vl
991: WHERE list_source_type_id=p_list_src_field_rec.list_source_type_id
992: and source_column_name = p_list_src_field_rec.source_column_name
993: and list_source_field_id <> p_list_src_field_rec.list_source_field_id;
994:

Line 998: -- FROM ams_list_src_fields_vl

994:
995: CURSOR c_fldcolname_crt 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 1011: FROM ams_list_src_fields_vl

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

Line 1016: FROM ams_list_src_fields_vl

1012: WHERE list_source_type_id=p_list_src_field_rec.list_source_type_id
1013: AND field_column_name = p_list_src_field_rec.field_column_name
1014: UNION ALL
1015: SELECT *
1016: FROM ams_list_src_fields_vl
1017: WHERE list_source_type_id IN
1018: ( SELECT sub_source_type_id
1019: FROM ams_list_src_type_assocs
1020: WHERE ( master_source_type_id = p_list_src_field_rec.list_source_type_id

Line 1029: -- FROM ams_list_src_fields_vl

1025:
1026: CURSOR c_fldcolname_upd IS
1027: -- Bug 3664542, SOLIN SQL Repository, tuning
1028: -- SELECT *
1029: -- FROM ams_list_src_fields_vl
1030: -- WHERE
1031: -- (list_source_type_id=p_list_src_field_rec.list_source_type_id
1032: -- OR list_source_type_id IN
1033: -- ( SELECT sub_source_type_id

Line 1043: FROM ams_list_src_fields_vl

1039: -- )
1040: -- AND field_column_name = p_list_src_field_rec.field_column_name
1041: -- AND list_source_field_id <> p_list_src_field_rec.list_source_field_id;
1042: SELECT *
1043: FROM ams_list_src_fields_vl
1044: WHERE list_source_type_id=p_list_src_field_rec.list_source_type_id
1045: AND field_column_name = p_list_src_field_rec.field_column_name
1046: AND list_source_field_id <> p_list_src_field_rec.list_source_field_id
1047: UNION ALL

Line 1049: FROM ams_list_src_fields_vl

1045: AND field_column_name = p_list_src_field_rec.field_column_name
1046: AND list_source_field_id <> p_list_src_field_rec.list_source_field_id
1047: UNION ALL
1048: SELECT *
1049: FROM ams_list_src_fields_vl
1050: WHERE list_source_type_id IN
1051: ( SELECT sub_source_type_id
1052: FROM ams_list_src_type_assocs
1053: WHERE ( master_source_type_id = p_list_src_field_rec.list_source_type_id

Line 1208: FROM ams_list_src_fields_vl

1204: l_return_status VARCHAR2(1);
1205:
1206: CURSOR c_complete IS
1207: SELECT *
1208: FROM ams_list_src_fields_vl
1209: WHERE list_source_field_id = p_list_src_field_rec.list_source_field_id;
1210: l_list_src_field_rec c_complete%ROWTYPE;
1211: BEGIN
1212: x_complete_rec := p_list_src_field_rec;