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_FIELDS

Line 2712: FROM ams_list_src_fields b, ams_list_src_types c

2708: c.source_object_name,
2709: b.source_column_name,
2710: b.field_data_type
2711: BULK COLLECT INTO :1 ,:2 ,:3 ,:4
2712: FROM ams_list_src_fields b, ams_list_src_types c
2713: WHERE b.list_source_type_id = c.list_source_type_id
2714: AND c.list_source_type = ''TARGET''
2715: and b.DE_LIST_SOURCE_TYPE_CODE IN '|| l_data_source_types ||
2716: ' AND b.ROWID >= (SELECT MAX(a.ROWID)

Line 2717: FROM ams_list_src_fields a

2713: WHERE b.list_source_type_id = c.list_source_type_id
2714: AND c.list_source_type = ''TARGET''
2715: and b.DE_LIST_SOURCE_TYPE_CODE IN '|| l_data_source_types ||
2716: ' AND b.ROWID >= (SELECT MAX(a.ROWID)
2717: FROM ams_list_src_fields a
2718: WHERE a.field_column_name= b.field_column_name
2719: AND a.DE_LIST_SOURCE_TYPE_CODE IN '
2720: || l_data_source_types || ') ;
2721: END; '

Line 3009: and exists (select 'x' from ams_list_src_fields

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'
3009: and exists (select 'x' from ams_list_src_fields
3010: where list_source_type_id = b.sub_source_type_id
3011: and field_column_name is not null) ;
3012:
3013: p_mapping_subtype_rec c_mapping_subtypes%rowtype;

Line 6432: FROM ams_list_src_fields

6428: AMS_LIST_SRC_TYPES.LIST_SOURCE_TYPE_ID%TYPE)
6429: IS
6430: SELECT field_column_name,
6431: source_column_name
6432: FROM ams_list_src_fields
6433: WHERE list_source_type_id = p_list_source_type_id
6434: and used_in_list_entries = 'Y';
6435:
6436:

Line 6476: from ams_list_src_fields

6472:
6473: l_add_where_clause VARCHAR2(2000);
6474: cursor c_source_map is
6475: select field_column_name
6476: from ams_list_src_fields
6477: where list_source_type_id = l_list_source_type_id--l_sub_source_type_id
6478: and source_column_name = l_dummy_pk_column;
6479:
6480: l_dummy_sr_column AMS_LIST_SRC_FIELDS.Field_column_name%TYPE;

Line 6480: l_dummy_sr_column AMS_LIST_SRC_FIELDS.Field_column_name%TYPE;

6476: from ams_list_src_fields
6477: where list_source_type_id = l_list_source_type_id--l_sub_source_type_id
6478: and source_column_name = l_dummy_pk_column;
6479:
6480: l_dummy_sr_column AMS_LIST_SRC_FIELDS.Field_column_name%TYPE;
6481: l_no_of_chunks number;
6482:
6483: x_msg_count number;
6484: x_msg_data varchar2(1000);

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

6850: l_ds_enabled_flag VARCHAR2(1);
6851: -- SOLIN, end
6852:
6853: cursor c_master_ds_fields_mapped is
6854: select 'Y' from ams_list_src_fields fd, ams_list_headers_all hd, ams_list_src_types ty
6855: where hd.list_header_id = p_list_header_id
6856: and hd.LIST_SOURCE_TYPE = ty.source_type_code
6857: and ty.list_source_type_id = fd.LIST_SOURCE_TYPE_ID
6858: and fd.FIELD_COLUMN_NAME is NOT NULL;

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

6857: and ty.list_source_type_id = fd.LIST_SOURCE_TYPE_ID
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

Line 6876: ams_list_src_fields d

6872: (
6873: SELECT d.field_column_name field_column_name1,d.field_column_name
6874: FROM ams_list_src_types a,
6875: ams_list_headers_all b,
6876: ams_list_src_fields d
6877: WHERE a.source_type_code = b.list_source_type
6878: and b.list_header_id = p_list_header_id
6879: and d.list_source_type_id = a.list_source_type_id
6880: and d.USED_IN_LIST_ENTRIES = 'Y'

Line 6885: ams_list_src_fields d,

6881: union all
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

Line 6905: ams_list_src_fields d

6901: cursor c_get_dup_mapping(p_col_name in varchar2) is
6902: SELECT d.source_column_name, d.field_column_name , d.de_list_source_type_code stc
6903: FROM ams_list_src_types a,
6904: ams_list_headers_all b,
6905: ams_list_src_fields d
6906: WHERE a.source_type_code = b.list_source_type
6907: and b.list_header_id = g_list_header_id
6908: and d.list_source_type_id = a.list_source_type_id
6909: and d.field_column_name = p_col_name

Line 6915: ams_list_src_fields d,

6911: union all
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

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

9481:
9482: l_list_field_mapped varchar2(1);
9483:
9484: cursor c_master_ds_fields_mapped is
9485: select 'Y' from ams_list_src_fields fd, ams_list_headers_all hd, ams_list_src_types ty
9486: where hd.list_header_id = p_list_header_id
9487: and hd.LIST_SOURCE_TYPE = ty.source_type_code
9488: and ty.list_source_type_id = fd.LIST_SOURCE_TYPE_ID
9489: and fd.FIELD_COLUMN_NAME is NOT NULL;

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

9488: and ty.list_source_type_id = fd.LIST_SOURCE_TYPE_ID
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

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

9518: l_ds_enabled_flag VARCHAR2(1);
9519: -- SOLIN, end
9520:
9521: cursor c_master_ds_tca_mapped is
9522: select 'Y' from ams_list_src_fields fd, ams_list_headers_all hd, ams_list_src_types ty
9523: where hd.list_header_id = p_list_header_id
9524: and hd.LIST_SOURCE_TYPE = ty.source_type_code
9525: and ty.list_source_type_id = fd.LIST_SOURCE_TYPE_ID
9526: and fd.tca_column_id is NOT NULL;

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

9525: and ty.list_source_type_id = fd.LIST_SOURCE_TYPE_ID
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

Line 9543: ams_list_src_fields d

9539: (
9540: SELECT d.field_column_name field_column_name1,d.field_column_name
9541: FROM ams_list_src_types a,
9542: ams_list_headers_all b,
9543: ams_list_src_fields d
9544: WHERE a.source_type_code = b.list_source_type
9545: and b.list_header_id = p_list_header_id
9546: and d.list_source_type_id = a.list_source_type_id
9547: and d.USED_IN_LIST_ENTRIES = 'Y'

Line 9552: ams_list_src_fields d,

9548: union all
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

Line 9573: ams_list_src_fields d

9569: cursor c_get_dup_mapping(p_col_name in varchar2) is
9570: SELECT d.source_column_name, d.field_column_name , d.de_list_source_type_code stc
9571: FROM ams_list_src_types a,
9572: ams_list_headers_all b,
9573: ams_list_src_fields d
9574: WHERE a.source_type_code = b.list_source_type
9575: and b.list_header_id = g_list_header_id
9576: and d.list_source_type_id = a.list_source_type_id
9577: and d.field_column_name = p_col_name

Line 9583: ams_list_src_fields d,

9579: union all
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

Line 12357: FROM ams_list_src_fields b, ams_list_src_types c

12353: c.source_object_name,
12354: b.source_column_name,
12355: b.field_data_type
12356: BULK COLLECT INTO :1 ,:2 ,:3 ,:4
12357: FROM ams_list_src_fields b, ams_list_src_types c
12358: WHERE b.list_source_type_id = c.list_source_type_id
12359: and b.DE_LIST_SOURCE_TYPE_CODE IN '|| l_data_source_types ||
12360: ' AND b.ROWID >= (SELECT MAX(a.ROWID)
12361: FROM ams_list_src_fields a

Line 12361: FROM ams_list_src_fields a

12357: FROM ams_list_src_fields b, ams_list_src_types c
12358: WHERE b.list_source_type_id = c.list_source_type_id
12359: and b.DE_LIST_SOURCE_TYPE_CODE IN '|| l_data_source_types ||
12360: ' AND b.ROWID >= (SELECT MAX(a.ROWID)
12361: FROM ams_list_src_fields a
12362: WHERE a.field_column_name= b.field_column_name
12363: AND a.DE_LIST_SOURCE_TYPE_CODE IN '
12364: || l_data_source_types || ') ;
12365: END; '

Line 12992: from ams_list_src_fields flds, AMS_DS_TCA_ENTITY_COLS tca,

12988: and enabled_flag = 'Y'; --bmuthukr. R12 Need to upload only the enabled entries.
12989:
12990: cursor c_tca_columns is
12991: select flds.field_column_name , tca.column_name
12992: from ams_list_src_fields flds, AMS_DS_TCA_ENTITY_COLS tca,
12993: ams_list_headers_all hdr, ams_list_src_types typ
12994: where hdr.list_header_id = p_list_header_id
12995: and hdr.LIST_SOURCE_TYPE = typ.SOURCE_TYPE_CODE
12996: and typ.list_source_type_id = flds.list_source_type_id