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.

[Home] [Help]

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 6439: FROM ams_list_src_fields

6435: AMS_LIST_SRC_TYPES.LIST_SOURCE_TYPE_ID%TYPE)
6436: IS
6437: SELECT field_column_name,
6438: source_column_name
6439: FROM ams_list_src_fields
6440: WHERE list_source_type_id = p_list_source_type_id
6441: and used_in_list_entries = 'Y';
6442:
6443:

Line 6483: from ams_list_src_fields

6479:
6480: l_add_where_clause VARCHAR2(2000);
6481: cursor c_source_map is
6482: select field_column_name
6483: from ams_list_src_fields
6484: where list_source_type_id = l_list_source_type_id--l_sub_source_type_id
6485: and source_column_name = l_dummy_pk_column;
6486:
6487: l_dummy_sr_column AMS_LIST_SRC_FIELDS.Field_column_name%TYPE;

Line 6487: l_dummy_sr_column AMS_LIST_SRC_FIELDS.Field_column_name%TYPE;

6483: from ams_list_src_fields
6484: where list_source_type_id = l_list_source_type_id--l_sub_source_type_id
6485: and source_column_name = l_dummy_pk_column;
6486:
6487: l_dummy_sr_column AMS_LIST_SRC_FIELDS.Field_column_name%TYPE;
6488: l_no_of_chunks number;
6489:
6490: x_msg_count number;
6491: x_msg_data varchar2(1000);

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

6907: l_ds_enabled_flag VARCHAR2(1);
6908: -- SOLIN, end
6909:
6910: cursor c_master_ds_fields_mapped is
6911: select 'Y' from ams_list_src_fields fd, ams_list_headers_all hd, ams_list_src_types ty
6912: where hd.list_header_id = p_list_header_id
6913: and hd.LIST_SOURCE_TYPE = ty.source_type_code
6914: and ty.list_source_type_id = fd.LIST_SOURCE_TYPE_ID
6915: and fd.FIELD_COLUMN_NAME is NOT NULL;

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

6914: and ty.list_source_type_id = fd.LIST_SOURCE_TYPE_ID
6915: and fd.FIELD_COLUMN_NAME is NOT NULL;
6916:
6917: cursor c_child_ds_fields_mapped is
6918: select 'Y' from ams_list_src_fields fd, ams_list_headers_all hd, ams_list_src_types ty,
6919: ams_list_src_type_assocs ats
6920: where hd.list_header_id = p_list_header_id
6921: and hd.LIST_SOURCE_TYPE = ty.source_type_code
6922: and ty.list_source_type_id = ats.master_source_type_id

Line 6933: ams_list_src_fields d

6929: (
6930: SELECT d.field_column_name field_column_name1,d.field_column_name
6931: FROM ams_list_src_types a,
6932: ams_list_headers_all b,
6933: ams_list_src_fields d
6934: WHERE a.source_type_code = b.list_source_type
6935: and b.list_header_id = p_list_header_id
6936: and d.list_source_type_id = a.list_source_type_id
6937: and d.USED_IN_LIST_ENTRIES = 'Y'

Line 6942: ams_list_src_fields d,

6938: union all
6939: SELECT d.field_column_name field_column_name1,d.field_column_name
6940: FROM ams_list_src_types a,
6941: ams_list_headers_all b,
6942: ams_list_src_fields d,
6943: ams_list_src_type_assocs e
6944: WHERE a.source_type_code = b.list_source_type
6945: and b.list_header_id = p_list_header_id
6946: and e.master_source_type_id = a.list_source_type_id

Line 6962: ams_list_src_fields d

6958: cursor c_get_dup_mapping(p_col_name in varchar2) is
6959: SELECT d.source_column_name, d.field_column_name , d.de_list_source_type_code stc
6960: FROM ams_list_src_types a,
6961: ams_list_headers_all b,
6962: ams_list_src_fields d
6963: WHERE a.source_type_code = b.list_source_type
6964: and b.list_header_id = g_list_header_id
6965: and d.list_source_type_id = a.list_source_type_id
6966: and d.field_column_name = p_col_name

Line 6972: ams_list_src_fields d,

6968: union all
6969: SELECT d.source_column_name, d.field_column_name, d.de_list_source_type_code stc
6970: FROM ams_list_src_types a,
6971: ams_list_headers_all b,
6972: ams_list_src_fields d,
6973: ams_list_src_type_assocs e
6974: WHERE a.source_type_code = b.list_source_type
6975: and b.list_header_id = g_list_header_id
6976: and e.master_source_type_id = a.list_source_type_id

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

9582:
9583: l_list_field_mapped varchar2(1);
9584:
9585: cursor c_master_ds_fields_mapped is
9586: select 'Y' from ams_list_src_fields fd, ams_list_headers_all hd, ams_list_src_types ty
9587: where hd.list_header_id = p_list_header_id
9588: and hd.LIST_SOURCE_TYPE = ty.source_type_code
9589: and ty.list_source_type_id = fd.LIST_SOURCE_TYPE_ID
9590: and fd.FIELD_COLUMN_NAME is NOT NULL;

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

9589: and ty.list_source_type_id = fd.LIST_SOURCE_TYPE_ID
9590: and fd.FIELD_COLUMN_NAME is NOT NULL;
9591:
9592: cursor c_child_ds_fields_mapped is
9593: select 'Y' from ams_list_src_fields fd, ams_list_headers_all hd, ams_list_src_types ty,
9594: ams_list_src_type_assocs ats
9595: where hd.list_header_id = p_list_header_id
9596: and hd.LIST_SOURCE_TYPE = ty.source_type_code
9597: and ty.list_source_type_id = ats.master_source_type_id

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

9619: l_ds_enabled_flag VARCHAR2(1);
9620: -- SOLIN, end
9621:
9622: cursor c_master_ds_tca_mapped is
9623: select 'Y' from ams_list_src_fields fd, ams_list_headers_all hd, ams_list_src_types ty
9624: where hd.list_header_id = p_list_header_id
9625: and hd.LIST_SOURCE_TYPE = ty.source_type_code
9626: and ty.list_source_type_id = fd.LIST_SOURCE_TYPE_ID
9627: and fd.tca_column_id is NOT NULL;

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

9626: and ty.list_source_type_id = fd.LIST_SOURCE_TYPE_ID
9627: and fd.tca_column_id is NOT NULL;
9628:
9629: cursor c_child_ds_tca_mapped is
9630: select 'Y' from ams_list_src_fields fd, ams_list_headers_all hd, ams_list_src_types ty,
9631: ams_list_src_type_assocs ats
9632: where hd.list_header_id = p_list_header_id
9633: and hd.LIST_SOURCE_TYPE = ty.source_type_code
9634: and ty.list_source_type_id = ats.master_source_type_id

Line 9644: ams_list_src_fields d

9640: (
9641: SELECT d.field_column_name field_column_name1,d.field_column_name
9642: FROM ams_list_src_types a,
9643: ams_list_headers_all b,
9644: ams_list_src_fields d
9645: WHERE a.source_type_code = b.list_source_type
9646: and b.list_header_id = p_list_header_id
9647: and d.list_source_type_id = a.list_source_type_id
9648: and d.USED_IN_LIST_ENTRIES = 'Y'

Line 9653: ams_list_src_fields d,

9649: union all
9650: SELECT d.field_column_name field_column_name1,d.field_column_name
9651: FROM ams_list_src_types a,
9652: ams_list_headers_all b,
9653: ams_list_src_fields d,
9654: ams_list_src_type_assocs e
9655: WHERE a.source_type_code = b.list_source_type
9656: and b.list_header_id = p_list_header_id
9657: and e.master_source_type_id = a.list_source_type_id

Line 9674: ams_list_src_fields d

9670: cursor c_get_dup_mapping(p_col_name in varchar2) is
9671: SELECT d.source_column_name, d.field_column_name , d.de_list_source_type_code stc
9672: FROM ams_list_src_types a,
9673: ams_list_headers_all b,
9674: ams_list_src_fields d
9675: WHERE a.source_type_code = b.list_source_type
9676: and b.list_header_id = g_list_header_id
9677: and d.list_source_type_id = a.list_source_type_id
9678: and d.field_column_name = p_col_name

Line 9684: ams_list_src_fields d,

9680: union all
9681: SELECT d.source_column_name, d.field_column_name, d.de_list_source_type_code stc
9682: FROM ams_list_src_types a,
9683: ams_list_headers_all b,
9684: ams_list_src_fields d,
9685: ams_list_src_type_assocs e
9686: WHERE a.source_type_code = b.list_source_type
9687: and b.list_header_id = g_list_header_id
9688: and e.master_source_type_id = a.list_source_type_id

Line 12458: FROM ams_list_src_fields b, ams_list_src_types c

12454: c.source_object_name,
12455: b.source_column_name,
12456: b.field_data_type
12457: BULK COLLECT INTO :1 ,:2 ,:3 ,:4
12458: FROM ams_list_src_fields b, ams_list_src_types c
12459: WHERE b.list_source_type_id = c.list_source_type_id
12460: and b.DE_LIST_SOURCE_TYPE_CODE IN '|| l_data_source_types ||
12461: ' AND b.ROWID >= (SELECT MAX(a.ROWID)
12462: FROM ams_list_src_fields a

Line 12462: FROM ams_list_src_fields a

12458: FROM ams_list_src_fields b, ams_list_src_types c
12459: WHERE b.list_source_type_id = c.list_source_type_id
12460: and b.DE_LIST_SOURCE_TYPE_CODE IN '|| l_data_source_types ||
12461: ' AND b.ROWID >= (SELECT MAX(a.ROWID)
12462: FROM ams_list_src_fields a
12463: WHERE a.field_column_name= b.field_column_name
12464: AND a.DE_LIST_SOURCE_TYPE_CODE IN '
12465: || l_data_source_types || ') ;
12466: END; '

Line 13093: from ams_list_src_fields flds, AMS_DS_TCA_ENTITY_COLS tca,

13089: and enabled_flag = 'Y'; --bmuthukr. R12 Need to upload only the enabled entries.
13090:
13091: cursor c_tca_columns is
13092: select flds.field_column_name , tca.column_name
13093: from ams_list_src_fields flds, AMS_DS_TCA_ENTITY_COLS tca,
13094: ams_list_headers_all hdr, ams_list_src_types typ
13095: where hdr.list_header_id = p_list_header_id
13096: and hdr.LIST_SOURCE_TYPE = typ.SOURCE_TYPE_CODE
13097: and typ.list_source_type_id = flds.list_source_type_id