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_ACT_LIST_PVT dependencies on AMS_LIST_SRC_TYPES

Line 2301: ams_list_src_types t

2297: --to the PARTY_ID column in ams_list_ensties
2298: CURSOR c_check_DS_PK_mapping(l_source_type VARCHAR2) is
2299: SELECT 1
2300: FROM ams_list_src_fields f,
2301: ams_list_src_types t
2302: WHERE t.LIST_SOURCE_TYPE_ID = f.LIST_SOURCE_TYPE_ID
2303: AND f.FIELD_COLUMN_NAME = 'PARTY_ID'
2304: AND f.SOURCE_COLUMN_NAME = t.SOURCE_OBJECT_PK_FIELD
2305: AND t.SOURCE_TYPE_CODE = l_source_type;

Line 2621: select 'Y' from ams_list_src_fields fd, ams_list_headers_all hd, ams_list_src_types ty

2617: l_tca_field_mapped varchar2(1);
2618:
2619: cursor c_master_ds_tca_mapped(list_head_id IN NUMBER)
2620: IS
2621: select 'Y' from ams_list_src_fields fd, ams_list_headers_all hd, ams_list_src_types ty
2622: where hd.list_header_id = list_head_id
2623: and hd.LIST_SOURCE_TYPE = ty.source_type_code
2624: and ty.list_source_type_id = fd.LIST_SOURCE_TYPE_ID
2625: and fd.tca_column_id is NOT NULL;

Line 2634: from ams_list_src_types stypes, ams_list_headers_all list

2630:
2631: cursor c_remote_list(list_head_id in number)
2632: IS
2633: select nvl(stypes.remote_flag,'N')
2634: from ams_list_src_types stypes, ams_list_headers_all list
2635: where list.list_source_type = stypes.source_type_code
2636: and list_header_id = list_head_id ;
2637:
2638: /* added by savio for p1 bug 3817724 */

Line 3322: from ams_list_src_types

3318: l_source_col_tbl JTF_VARCHAR2_TABLE_100;
3319: l_view_tbl JTF_VARCHAR2_TABLE_100;
3320: cursor c_master_source_type is
3321: select source_object_name , source_object_name || '.' || source_object_pk_field
3322: from ams_list_src_types
3323: where source_type_code = p_master_type;
3324: cursor c_child_source_type (l_child_src_type varchar2 )is
3325: select a.source_object_name ,
3326: a.source_object_name || '.' || b.sub_source_type_pk_column

Line 3328: from ams_list_src_types a, ams_list_src_type_assocs b

3324: cursor c_child_source_type (l_child_src_type varchar2 )is
3325: select a.source_object_name ,
3326: a.source_object_name || '.' || b.sub_source_type_pk_column
3327: ,b.master_source_type_pk_column
3328: from ams_list_src_types a, ams_list_src_type_assocs b
3329: where a.source_type_code = l_child_src_type
3330: and b.sub_source_type_id = a.list_source_type_id;
3331: l_count number;
3332: l_master_object_name varchar2(4000);

Line 3398: FROM ams_list_src_fields b, ams_list_src_types c

3394: SELECT b.field_column_name ,
3395: c.source_object_name,
3396: b.source_column_name
3397: BULK COLLECT INTO :1 ,:2 ,:3
3398: FROM ams_list_src_fields b, ams_list_src_types c
3399: WHERE b.list_source_type_id = c.list_source_type_id
3400: and b.DE_LIST_SOURCE_TYPE_CODE IN '|| l_data_source_types ||
3401: ' AND b.ROWID >= (SELECT MAX(a.ROWID)
3402: FROM ams_list_src_fields a