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_TYPES

Line 1201: p_source_type_code AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%TYPE) IS

1197: ---------------------------------------------------------------------------
1198:
1199: PROCEDURE insert_list_mapping_usage
1200: (p_list_header_id AMS_LIST_HEADERS_ALL.LIST_HEADER_ID%TYPE,
1201: p_source_type_code AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%TYPE) IS
1202:
1203: l_found NUMBER;
1204: BEGIN
1205:

Line 2635: from ams_list_src_types

2631: l_view_tbl JTF_VARCHAR2_TABLE_100;
2632: l_source_col_dt_tbl JTF_VARCHAR2_TABLE_100;
2633: cursor c_master_source_type is
2634: select source_object_name , source_object_name || '.' || source_object_pk_field , list_source_type_id
2635: from ams_list_src_types
2636: where source_type_code = p_master_type;
2637: l_master_source_type_id number;
2638: cursor c_child_source_type (l_child_src_type varchar2 )is
2639: select a.source_object_name ,

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 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 3003: from ams_list_src_types a,

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
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'

Line 3112: FROM ams_list_src_types

3108: SELECT list_source_type_id,
3109: source_type_code,
3110: source_object_name,
3111: source_object_pk_field
3112: FROM ams_list_src_types
3113: WHERE master_source_type_flag = 'Y'
3114: AND list_source_type in ('ANALYTICS', 'TARGET');
3115:
3116: cursor c_default_mapping_types IS

Line 3121: FROM ams_list_src_types a,ams_list_headers_all b

3117: SELECT a.list_source_type_id,
3118: a.source_type_code,
3119: a.source_object_name,
3120: a.source_object_pk_field
3121: FROM ams_list_src_types a,ams_list_headers_all b
3122: WHERE a.master_source_type_flag = 'Y'
3123: and a.source_type_code = b.list_source_type
3124: and b.list_header_id = g_list_header_id
3125: AND a.list_source_type in ('ANALYTICS', 'TARGET');

Line 3472: ams_list_src_types lc

3468: cursor cur_primary_key_sql is
3469: SELECT lc.SOURCE_OBJECT_NAME, lc.SOURCE_OBJECT_PK_FIELD
3470: FROM ams_list_queries_all lq,
3471: ams_list_headers_all lh,
3472: ams_list_src_types lc
3473: WHERE lq.list_query_id = p_incl_object_id
3474: and lq.ARC_ACT_LIST_QUERY_USED_BY = 'LIST'
3475: and lq.ACT_LIST_QUERY_USED_BY_ID = lh.list_header_id
3476: and lc.source_type_code = lh.list_source_type;

Line 6400: FROM ams_list_src_types a,

6396: a.source_type_code,
6397: a.source_object_name,
6398: a.source_object_pk_field,
6399: a.master_source_type_flag
6400: FROM ams_list_src_types a,
6401: ams_list_src_type_usages b
6402: WHERE a.source_type_code = b.source_type_code
6403: AND b.list_header_id = p_list_header_id
6404: AND master_source_type_flag = 'Y' ;

Line 6412: ams_list_src_types als ,

6408: als.source_object_name,
6409: als.source_type_code,
6410: al.master_source_type_pk_column
6411: FROM ams_list_src_type_assocs al,
6412: ams_list_src_types als ,
6413: ams_list_src_type_usages b
6414: WHERE al.MASTER_SOURCE_TYPE_ID = c_master_type_id
6415: AND als.list_source_type_id = al.sub_source_type_id
6416: AND als.source_type_code = b.source_type_code

Line 6418: l_list_source_type_id AMS_LIST_SRC_TYPES.LIST_SOURCE_TYPE_ID%TYPE;

6414: WHERE al.MASTER_SOURCE_TYPE_ID = c_master_type_id
6415: AND als.list_source_type_id = al.sub_source_type_id
6416: AND als.source_type_code = b.source_type_code
6417: AND b.list_header_id = p_list_header_id ;
6418: l_list_source_type_id AMS_LIST_SRC_TYPES.LIST_SOURCE_TYPE_ID%TYPE;
6419: l_source_type_code AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%TYPE;
6420: l_source_object_name AMS_LIST_SRC_TYPES.SOURCE_OBJECT_NAME%TYPE;
6421: l_source_object_pk_field AMS_LIST_SRC_TYPES.SOURCE_OBJECT_PK_FIELD%TYPE;
6422: l_master_source_type_flag AMS_LIST_SRC_TYPES.MASTER_SOURCE_TYPE_FLAG%TYPE;

Line 6419: l_source_type_code AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%TYPE;

6415: AND als.list_source_type_id = al.sub_source_type_id
6416: AND als.source_type_code = b.source_type_code
6417: AND b.list_header_id = p_list_header_id ;
6418: l_list_source_type_id AMS_LIST_SRC_TYPES.LIST_SOURCE_TYPE_ID%TYPE;
6419: l_source_type_code AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%TYPE;
6420: l_source_object_name AMS_LIST_SRC_TYPES.SOURCE_OBJECT_NAME%TYPE;
6421: l_source_object_pk_field AMS_LIST_SRC_TYPES.SOURCE_OBJECT_PK_FIELD%TYPE;
6422: l_master_source_type_flag AMS_LIST_SRC_TYPES.MASTER_SOURCE_TYPE_FLAG%TYPE;
6423: l_sub_source_type_pk_column AMS_LIST_SRC_TYPE_ASSOCS.SUB_SOURCE_TYPE_PK_COLUMN%TYPE;

Line 6420: l_source_object_name AMS_LIST_SRC_TYPES.SOURCE_OBJECT_NAME%TYPE;

6416: AND als.source_type_code = b.source_type_code
6417: AND b.list_header_id = p_list_header_id ;
6418: l_list_source_type_id AMS_LIST_SRC_TYPES.LIST_SOURCE_TYPE_ID%TYPE;
6419: l_source_type_code AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%TYPE;
6420: l_source_object_name AMS_LIST_SRC_TYPES.SOURCE_OBJECT_NAME%TYPE;
6421: l_source_object_pk_field AMS_LIST_SRC_TYPES.SOURCE_OBJECT_PK_FIELD%TYPE;
6422: l_master_source_type_flag AMS_LIST_SRC_TYPES.MASTER_SOURCE_TYPE_FLAG%TYPE;
6423: l_sub_source_type_pk_column AMS_LIST_SRC_TYPE_ASSOCS.SUB_SOURCE_TYPE_PK_COLUMN%TYPE;
6424: l_dummy_pk_column AMS_LIST_SRC_TYPE_ASSOCS.master_SOURCE_TYPE_PK_COLUMN%TYPE;

Line 6421: l_source_object_pk_field AMS_LIST_SRC_TYPES.SOURCE_OBJECT_PK_FIELD%TYPE;

6417: AND b.list_header_id = p_list_header_id ;
6418: l_list_source_type_id AMS_LIST_SRC_TYPES.LIST_SOURCE_TYPE_ID%TYPE;
6419: l_source_type_code AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%TYPE;
6420: l_source_object_name AMS_LIST_SRC_TYPES.SOURCE_OBJECT_NAME%TYPE;
6421: l_source_object_pk_field AMS_LIST_SRC_TYPES.SOURCE_OBJECT_PK_FIELD%TYPE;
6422: l_master_source_type_flag AMS_LIST_SRC_TYPES.MASTER_SOURCE_TYPE_FLAG%TYPE;
6423: l_sub_source_type_pk_column AMS_LIST_SRC_TYPE_ASSOCS.SUB_SOURCE_TYPE_PK_COLUMN%TYPE;
6424: l_dummy_pk_column AMS_LIST_SRC_TYPE_ASSOCS.master_SOURCE_TYPE_PK_COLUMN%TYPE;
6425: l_SUB_SOURCE_TYPE_ID number;

Line 6422: l_master_source_type_flag AMS_LIST_SRC_TYPES.MASTER_SOURCE_TYPE_FLAG%TYPE;

6418: l_list_source_type_id AMS_LIST_SRC_TYPES.LIST_SOURCE_TYPE_ID%TYPE;
6419: l_source_type_code AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%TYPE;
6420: l_source_object_name AMS_LIST_SRC_TYPES.SOURCE_OBJECT_NAME%TYPE;
6421: l_source_object_pk_field AMS_LIST_SRC_TYPES.SOURCE_OBJECT_PK_FIELD%TYPE;
6422: l_master_source_type_flag AMS_LIST_SRC_TYPES.MASTER_SOURCE_TYPE_FLAG%TYPE;
6423: l_sub_source_type_pk_column AMS_LIST_SRC_TYPE_ASSOCS.SUB_SOURCE_TYPE_PK_COLUMN%TYPE;
6424: l_dummy_pk_column AMS_LIST_SRC_TYPE_ASSOCS.master_SOURCE_TYPE_PK_COLUMN%TYPE;
6425: l_SUB_SOURCE_TYPE_ID number;
6426: l_SUB_SOURCE_OBJECT_NAME varchar2(300);

Line 6427: l_sub_source_type_code AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%TYPE;

6423: l_sub_source_type_pk_column AMS_LIST_SRC_TYPE_ASSOCS.SUB_SOURCE_TYPE_PK_COLUMN%TYPE;
6424: l_dummy_pk_column AMS_LIST_SRC_TYPE_ASSOCS.master_SOURCE_TYPE_PK_COLUMN%TYPE;
6425: l_SUB_SOURCE_TYPE_ID number;
6426: l_SUB_SOURCE_OBJECT_NAME varchar2(300);
6427: l_sub_source_type_code AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%TYPE;
6428: l_sub_source_master_type AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%TYPE;
6429: l_source_code AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%TYPE;
6430:
6431: ------------------------------------------------------------

Line 6428: l_sub_source_master_type AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%TYPE;

6424: l_dummy_pk_column AMS_LIST_SRC_TYPE_ASSOCS.master_SOURCE_TYPE_PK_COLUMN%TYPE;
6425: l_SUB_SOURCE_TYPE_ID number;
6426: l_SUB_SOURCE_OBJECT_NAME varchar2(300);
6427: l_sub_source_type_code AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%TYPE;
6428: l_sub_source_master_type AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%TYPE;
6429: l_source_code AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%TYPE;
6430:
6431: ------------------------------------------------------------
6432: --Retrive all the fields to be used for each mapping type.--

Line 6429: l_source_code AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%TYPE;

6425: l_SUB_SOURCE_TYPE_ID number;
6426: l_SUB_SOURCE_OBJECT_NAME varchar2(300);
6427: l_sub_source_type_code AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%TYPE;
6428: l_sub_source_master_type AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%TYPE;
6429: l_source_code AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%TYPE;
6430:
6431: ------------------------------------------------------------
6432: --Retrive all the fields to be used for each mapping type.--
6433: ------------------------------------------------------------

Line 6435: AMS_LIST_SRC_TYPES.LIST_SOURCE_TYPE_ID%TYPE)

6431: ------------------------------------------------------------
6432: --Retrive all the fields to be used for each mapping type.--
6433: ------------------------------------------------------------
6434: CURSOR C_MAPPING_TYPE_FIELDS(p_list_source_type_id
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

Line 6846: from ams_list_src_types stypes, ams_list_headers_all list

6842: l_error_position varchar2(100);
6843:
6844: cursor c_remote_list is
6845: select nvl(stypes.remote_flag,'N') ,database_link
6846: from ams_list_src_types stypes, ams_list_headers_all list
6847: where list.list_source_type = stypes.source_type_code
6848: and list_header_id = p_list_header_id;
6849:
6850: l_list_selection varchar2(1);

Line 6902: FROM ams_list_src_types a,

6898: -- SOLIN, bug 4410333
6899: -- check whether datasource is enabled.
6900: cursor c_check_datasource(c_list_header_id NUMBER) is
6901: SELECT a.enabled_flag
6902: FROM ams_list_src_types a,
6903: ams_list_headers_all b
6904: WHERE a.source_type_code = b.list_source_type
6905: AND b.list_header_id = c_list_header_id;
6906:

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 6931: FROM ams_list_src_types a,

6927: CURSOR c_get_dup_fields(c_list_header_id NUMBER) IS
6928: SELECT min(master_child.field_column_name1) ,count(master_child.field_column_name) from
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

Line 6940: FROM ams_list_src_types a,

6936: and d.list_source_type_id = a.list_source_type_id
6937: and d.USED_IN_LIST_ENTRIES = 'Y'
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

Line 6960: FROM ams_list_src_types a,

6956: l_source_col_name varchar2(1000);
6957:
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

Line 6970: FROM ams_list_src_types a,

6966: and d.field_column_name = p_col_name
6967: and d.USED_IN_LIST_ENTRIES = 'Y'
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

Line 7944: FROM ams_list_src_types a

7940: l_action_rec AMS_ListAction_PVT.action_rec_type ;
7941: l_action_id number;
7942: cursor c_mapping_types(p_master_type varchar2) is
7943: SELECT list_source_type_id
7944: FROM ams_list_src_types a
7945: WHERE a.source_type_code = p_master_type
7946: AND a.master_source_type_flag = 'Y';
7947: cursor c_mapping_subtypes(p_master_type_id
7948: ams_list_src_type_assocs.master_source_type_id%type)is

Line 7950: from ams_list_src_types a,

7946: AND a.master_source_type_flag = 'Y';
7947: cursor c_mapping_subtypes(p_master_type_id
7948: ams_list_src_type_assocs.master_source_type_id%type)is
7949: select ','||''''||source_type_code||''''
7950: from ams_list_src_types a,
7951: ams_list_src_type_assocs b
7952: where b.master_source_type_id = p_master_type_id
7953: and b.sub_source_type_id = a.list_source_type_id;
7954:

Line 9529: from ams_list_src_types stypes, ams_list_headers_all list

9525:
9526:
9527: cursor c_remote_list is
9528: select nvl(stypes.remote_flag,'N') ,database_link
9529: from ams_list_src_types stypes, ams_list_headers_all list
9530: where list.list_source_type = stypes.source_type_code
9531: and list_header_id = p_list_header_id;
9532:
9533: l_list_selection varchar2(1);

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 9614: FROM ams_list_src_types a,

9610: -- SOLIN, bug 4410333
9611: -- check whether datasource is enabled.
9612: cursor c_check_datasource(c_list_header_id NUMBER) is
9613: SELECT a.enabled_flag
9614: FROM ams_list_src_types a,
9615: ams_list_headers_all b
9616: WHERE a.source_type_code = b.list_source_type
9617: AND b.list_header_id = c_list_header_id;
9618:

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 9642: FROM ams_list_src_types a,

9638: CURSOR c_get_dup_fields(c_list_header_id NUMBER) IS
9639: SELECT min(master_child.field_column_name1) ,count(master_child.field_column_name) from
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

Line 9651: FROM ams_list_src_types a,

9647: and d.list_source_type_id = a.list_source_type_id
9648: and d.USED_IN_LIST_ENTRIES = 'Y'
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

Line 9672: FROM ams_list_src_types a,

9668: l_source_col_name varchar2(1000);
9669:
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

Line 9682: FROM ams_list_src_types a,

9678: and d.field_column_name = p_col_name
9679: and d.USED_IN_LIST_ENTRIES = 'Y'
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

Line 10828: from ams_list_headers_all head, ams_list_src_types stypes

10824:
10825: l_list_header_id NUMBER;
10826: cursor c_migrate_list is
10827: select head.list_header_id
10828: from ams_list_headers_all head, ams_list_src_types stypes
10829: where head.status_code = 'AVAILABLE'
10830: and head.MIGRATION_DATE is NULL
10831: and head.list_source_type = stypes.source_type_code
10832: and stypes.remote_flag = 'Y';

Line 10876: from ams_list_src_types stypes, ams_list_headers_all list

10872:
10873:
10874: cursor c_dblink is
10875: select database_link
10876: from ams_list_src_types stypes, ams_list_headers_all list
10877: where list.list_source_type = stypes.source_type_code
10878: and list_header_id = p_list_header_id;
10879:
10880: begin

Line 12393: from ams_list_src_types

12389: l_view_tbl JTF_VARCHAR2_TABLE_100;
12390: l_source_col_dt_tbl JTF_VARCHAR2_TABLE_100;
12391: cursor c_master_source_type is
12392: select source_object_name , source_object_name || '.' || source_object_pk_field
12393: from ams_list_src_types
12394: where source_type_code = p_master_type;
12395: cursor c_child_source_type (l_child_src_type varchar2 )is
12396: select a.source_object_name ,
12397: a.source_object_name || '.' || b.sub_source_type_pk_column

Line 12399: from ams_list_src_types a, ams_list_src_type_assocs b

12395: cursor c_child_source_type (l_child_src_type varchar2 )is
12396: select a.source_object_name ,
12397: a.source_object_name || '.' || b.sub_source_type_pk_column
12398: ,b.master_source_type_pk_column
12399: from ams_list_src_types a, ams_list_src_type_assocs b
12400: where a.source_type_code = l_child_src_type
12401: and b.sub_source_type_id = a.list_source_type_id;
12402: l_count number;
12403: l_master_object_name varchar2(4000);

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 12759: ams_list_src_types lc

12755: cursor cur_primary_key_sql is
12756: SELECT lc.SOURCE_OBJECT_NAME, lc.SOURCE_OBJECT_PK_FIELD
12757: FROM ams_list_queries_all lq,
12758: ams_list_headers_all lh,
12759: ams_list_src_types lc
12760: WHERE lq.list_query_id = p_incl_object_id
12761: and lq.ARC_ACT_LIST_QUERY_USED_BY = 'LIST'
12762: and lq.ACT_LIST_QUERY_USED_BY_ID = lh.list_header_id
12763: and lc.source_type_code = lh.list_source_type;

Line 13094: ams_list_headers_all hdr, ams_list_src_types typ

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
13098: and flds.enabled_flag = 'Y'

Line 13103: select source_category from ams_list_src_types types, ams_list_headers_all head

13099: and used_in_list_entries = 'Y'
13100: and flds.tca_column_id = tca.ENTITY_COLUMN_ID;
13101:
13102: cursor c_data_type is
13103: select source_category from ams_list_src_types types, ams_list_headers_all head
13104: where head.list_header_id = p_list_header_id
13105: and head.list_source_type = types.source_type_code;
13106:
13107: l_prof VARCHAR2(50);

Line 14117: from ams_list_src_types stypes, ams_list_headers_all list

14113: cursor c_list_det is
14114: select stypes.database_link,
14115: list.remote_gen_flag,
14116: list.list_type
14117: from ams_list_src_types stypes, ams_list_headers_all list
14118: where list.list_source_type = stypes.source_type_code
14119: and list_header_id = p_list_header_id;
14120:
14121: cursor c_count_list_entries is