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_LISTGENERATION_PKG dependencies on AMS_LIST_SRC_TYPE_ASSOCS

Line 2642: from ams_list_src_types a, ams_list_src_type_assocs b

2638: cursor c_child_source_type (l_child_src_type varchar2 )is
2639: select a.source_object_name ,
2640: a.source_object_name || '.' || b.sub_source_type_pk_column
2641: ,b.master_source_type_pk_column
2642: from ams_list_src_types a, ams_list_src_type_assocs b
2643: where a.source_type_code = l_child_src_type
2644: and b.sub_source_type_id = a.list_source_type_id
2645: and b.master_source_type_id = l_master_source_type_id ;
2646: l_count number;

Line 3000: ams_list_src_type_assocs.master_source_type_id%type)

2996: x_found OUT NOCOPY varchar2 ) is
2997:
2998:
2999: cursor c_mapping_subtypes(p_master_type_id
3000: ams_list_src_type_assocs.master_source_type_id%type)
3001: IS
3002: select source_type_code
3003: from ams_list_src_types a,
3004: ams_list_src_type_assocs b

Line 3004: ams_list_src_type_assocs b

3000: ams_list_src_type_assocs.master_source_type_id%type)
3001: IS
3002: select source_type_code
3003: from ams_list_src_types a,
3004: ams_list_src_type_assocs b
3005: where b.master_source_type_id = p_master_type_id
3006: and b.sub_source_type_id = a.list_source_type_id
3007: and b.enabled_flag = 'Y'
3008: and a.enabled_flag = 'Y'

Line 6404: FROM ams_list_src_type_assocs al,

6400: al.SUB_SOURCE_TYPE_PK_COLUMN,
6401: als.source_object_name,
6402: als.source_type_code,
6403: al.master_source_type_pk_column
6404: FROM ams_list_src_type_assocs al,
6405: ams_list_src_types als ,
6406: ams_list_src_type_usages b
6407: WHERE al.MASTER_SOURCE_TYPE_ID = c_master_type_id
6408: AND als.list_source_type_id = al.sub_source_type_id

Line 6416: l_sub_source_type_pk_column AMS_LIST_SRC_TYPE_ASSOCS.SUB_SOURCE_TYPE_PK_COLUMN%TYPE;

6412: l_source_type_code AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%TYPE;
6413: l_source_object_name AMS_LIST_SRC_TYPES.SOURCE_OBJECT_NAME%TYPE;
6414: l_source_object_pk_field AMS_LIST_SRC_TYPES.SOURCE_OBJECT_PK_FIELD%TYPE;
6415: l_master_source_type_flag AMS_LIST_SRC_TYPES.MASTER_SOURCE_TYPE_FLAG%TYPE;
6416: l_sub_source_type_pk_column AMS_LIST_SRC_TYPE_ASSOCS.SUB_SOURCE_TYPE_PK_COLUMN%TYPE;
6417: l_dummy_pk_column AMS_LIST_SRC_TYPE_ASSOCS.master_SOURCE_TYPE_PK_COLUMN%TYPE;
6418: l_SUB_SOURCE_TYPE_ID number;
6419: l_SUB_SOURCE_OBJECT_NAME varchar2(300);
6420: l_sub_source_type_code AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%TYPE;

Line 6417: l_dummy_pk_column AMS_LIST_SRC_TYPE_ASSOCS.master_SOURCE_TYPE_PK_COLUMN%TYPE;

6413: l_source_object_name AMS_LIST_SRC_TYPES.SOURCE_OBJECT_NAME%TYPE;
6414: l_source_object_pk_field AMS_LIST_SRC_TYPES.SOURCE_OBJECT_PK_FIELD%TYPE;
6415: l_master_source_type_flag AMS_LIST_SRC_TYPES.MASTER_SOURCE_TYPE_FLAG%TYPE;
6416: l_sub_source_type_pk_column AMS_LIST_SRC_TYPE_ASSOCS.SUB_SOURCE_TYPE_PK_COLUMN%TYPE;
6417: l_dummy_pk_column AMS_LIST_SRC_TYPE_ASSOCS.master_SOURCE_TYPE_PK_COLUMN%TYPE;
6418: l_SUB_SOURCE_TYPE_ID number;
6419: l_SUB_SOURCE_OBJECT_NAME varchar2(300);
6420: l_sub_source_type_code AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%TYPE;
6421: l_sub_source_master_type AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%TYPE;

Line 6862: ams_list_src_type_assocs ats

6858: and fd.FIELD_COLUMN_NAME is NOT NULL;
6859:
6860: cursor c_child_ds_fields_mapped is
6861: select 'Y' from ams_list_src_fields fd, ams_list_headers_all hd, ams_list_src_types ty,
6862: ams_list_src_type_assocs ats
6863: where hd.list_header_id = p_list_header_id
6864: and hd.LIST_SOURCE_TYPE = ty.source_type_code
6865: and ty.list_source_type_id = ats.master_source_type_id
6866: and ats.sub_source_type_id = fd.LIST_SOURCE_TYPE_ID

Line 6886: ams_list_src_type_assocs e

6882: SELECT d.field_column_name field_column_name1,d.field_column_name
6883: FROM ams_list_src_types a,
6884: ams_list_headers_all b,
6885: ams_list_src_fields d,
6886: ams_list_src_type_assocs e
6887: WHERE a.source_type_code = b.list_source_type
6888: and b.list_header_id = p_list_header_id
6889: and e.master_source_type_id = a.list_source_type_id
6890: and d.list_source_type_id = e.sub_source_type_id

Line 6916: ams_list_src_type_assocs e

6912: SELECT d.source_column_name, d.field_column_name, d.de_list_source_type_code stc
6913: FROM ams_list_src_types a,
6914: ams_list_headers_all b,
6915: ams_list_src_fields d,
6916: ams_list_src_type_assocs e
6917: WHERE a.source_type_code = b.list_source_type
6918: and b.list_header_id = g_list_header_id
6919: and e.master_source_type_id = a.list_source_type_id
6920: and d.list_source_type_id = e.sub_source_type_id

Line 7860: ams_list_src_type_assocs.master_source_type_id%type)is

7856: FROM ams_list_src_types a
7857: WHERE a.source_type_code = p_master_type
7858: AND a.master_source_type_flag = 'Y';
7859: cursor c_mapping_subtypes(p_master_type_id
7860: ams_list_src_type_assocs.master_source_type_id%type)is
7861: select ','||''''||source_type_code||''''
7862: from ams_list_src_types a,
7863: ams_list_src_type_assocs b
7864: where b.master_source_type_id = p_master_type_id

Line 7863: ams_list_src_type_assocs b

7859: cursor c_mapping_subtypes(p_master_type_id
7860: ams_list_src_type_assocs.master_source_type_id%type)is
7861: select ','||''''||source_type_code||''''
7862: from ams_list_src_types a,
7863: ams_list_src_type_assocs b
7864: where b.master_source_type_id = p_master_type_id
7865: and b.sub_source_type_id = a.list_source_type_id;
7866:
7867: l_master_type_id number;

Line 9493: ams_list_src_type_assocs ats

9489: and fd.FIELD_COLUMN_NAME is NOT NULL;
9490:
9491: cursor c_child_ds_fields_mapped is
9492: select 'Y' from ams_list_src_fields fd, ams_list_headers_all hd, ams_list_src_types ty,
9493: ams_list_src_type_assocs ats
9494: where hd.list_header_id = p_list_header_id
9495: and hd.LIST_SOURCE_TYPE = ty.source_type_code
9496: and ty.list_source_type_id = ats.master_source_type_id
9497: and ats.sub_source_type_id = fd.LIST_SOURCE_TYPE_ID

Line 9530: ams_list_src_type_assocs ats

9526: and fd.tca_column_id is NOT NULL;
9527:
9528: cursor c_child_ds_tca_mapped is
9529: select 'Y' from ams_list_src_fields fd, ams_list_headers_all hd, ams_list_src_types ty,
9530: ams_list_src_type_assocs ats
9531: where hd.list_header_id = p_list_header_id
9532: and hd.LIST_SOURCE_TYPE = ty.source_type_code
9533: and ty.list_source_type_id = ats.master_source_type_id
9534: and ats.sub_source_type_id = fd.LIST_SOURCE_TYPE_ID

Line 9553: ams_list_src_type_assocs e

9549: SELECT d.field_column_name field_column_name1,d.field_column_name
9550: FROM ams_list_src_types a,
9551: ams_list_headers_all b,
9552: ams_list_src_fields d,
9553: ams_list_src_type_assocs e
9554: WHERE a.source_type_code = b.list_source_type
9555: and b.list_header_id = p_list_header_id
9556: and e.master_source_type_id = a.list_source_type_id
9557: and d.list_source_type_id = e.sub_source_type_id

Line 9584: ams_list_src_type_assocs e

9580: SELECT d.source_column_name, d.field_column_name, d.de_list_source_type_code stc
9581: FROM ams_list_src_types a,
9582: ams_list_headers_all b,
9583: ams_list_src_fields d,
9584: ams_list_src_type_assocs e
9585: WHERE a.source_type_code = b.list_source_type
9586: and b.list_header_id = g_list_header_id
9587: and e.master_source_type_id = a.list_source_type_id
9588: and d.list_source_type_id = e.sub_source_type_id

Line 12298: from ams_list_src_types a, ams_list_src_type_assocs b

12294: cursor c_child_source_type (l_child_src_type varchar2 )is
12295: select a.source_object_name ,
12296: a.source_object_name || '.' || b.sub_source_type_pk_column
12297: ,b.master_source_type_pk_column
12298: from ams_list_src_types a, ams_list_src_type_assocs b
12299: where a.source_type_code = l_child_src_type
12300: and b.sub_source_type_id = a.list_source_type_id;
12301: l_count number;
12302: l_master_object_name varchar2(4000);