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

6389: a.source_type_code,
6390: a.source_object_name,
6391: a.source_object_pk_field,
6392: a.master_source_type_flag
6393: FROM ams_list_src_types a,
6394: ams_list_src_type_usages b
6395: WHERE a.source_type_code = b.source_type_code
6396: AND b.list_header_id = p_list_header_id
6397: AND master_source_type_flag = 'Y' ;

Line 6405: ams_list_src_types als ,

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
6409: AND als.source_type_code = b.source_type_code

Line 6411: l_list_source_type_id AMS_LIST_SRC_TYPES.LIST_SOURCE_TYPE_ID%TYPE;

6407: WHERE al.MASTER_SOURCE_TYPE_ID = c_master_type_id
6408: AND als.list_source_type_id = al.sub_source_type_id
6409: AND als.source_type_code = b.source_type_code
6410: AND b.list_header_id = p_list_header_id ;
6411: l_list_source_type_id AMS_LIST_SRC_TYPES.LIST_SOURCE_TYPE_ID%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;

Line 6412: l_source_type_code AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%TYPE;

6408: AND als.list_source_type_id = al.sub_source_type_id
6409: AND als.source_type_code = b.source_type_code
6410: AND b.list_header_id = p_list_header_id ;
6411: l_list_source_type_id AMS_LIST_SRC_TYPES.LIST_SOURCE_TYPE_ID%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;

Line 6413: l_source_object_name AMS_LIST_SRC_TYPES.SOURCE_OBJECT_NAME%TYPE;

6409: AND als.source_type_code = b.source_type_code
6410: AND b.list_header_id = p_list_header_id ;
6411: l_list_source_type_id AMS_LIST_SRC_TYPES.LIST_SOURCE_TYPE_ID%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;

Line 6414: l_source_object_pk_field AMS_LIST_SRC_TYPES.SOURCE_OBJECT_PK_FIELD%TYPE;

6410: AND b.list_header_id = p_list_header_id ;
6411: l_list_source_type_id AMS_LIST_SRC_TYPES.LIST_SOURCE_TYPE_ID%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;

Line 6415: l_master_source_type_flag AMS_LIST_SRC_TYPES.MASTER_SOURCE_TYPE_FLAG%TYPE;

6411: l_list_source_type_id AMS_LIST_SRC_TYPES.LIST_SOURCE_TYPE_ID%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);

Line 6420: l_sub_source_type_code AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%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;
6422: l_source_code AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%TYPE;
6423:
6424: ------------------------------------------------------------

Line 6421: l_sub_source_master_type AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%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;
6422: l_source_code AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%TYPE;
6423:
6424: ------------------------------------------------------------
6425: --Retrive all the fields to be used for each mapping type.--

Line 6422: l_source_code AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%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;
6422: l_source_code AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%TYPE;
6423:
6424: ------------------------------------------------------------
6425: --Retrive all the fields to be used for each mapping type.--
6426: ------------------------------------------------------------

Line 6428: AMS_LIST_SRC_TYPES.LIST_SOURCE_TYPE_ID%TYPE)

6424: ------------------------------------------------------------
6425: --Retrive all the fields to be used for each mapping type.--
6426: ------------------------------------------------------------
6427: CURSOR C_MAPPING_TYPE_FIELDS(p_list_source_type_id
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

Line 6789: from ams_list_src_types stypes, ams_list_headers_all list

6785: l_error_position varchar2(100);
6786:
6787: cursor c_remote_list is
6788: select nvl(stypes.remote_flag,'N') ,database_link
6789: from ams_list_src_types stypes, ams_list_headers_all list
6790: where list.list_source_type = stypes.source_type_code
6791: and list_header_id = p_list_header_id;
6792:
6793: l_list_selection varchar2(1);

Line 6845: FROM ams_list_src_types a,

6841: -- SOLIN, bug 4410333
6842: -- check whether datasource is enabled.
6843: cursor c_check_datasource(c_list_header_id NUMBER) is
6844: SELECT a.enabled_flag
6845: FROM ams_list_src_types a,
6846: ams_list_headers_all b
6847: WHERE a.source_type_code = b.list_source_type
6848: AND b.list_header_id = c_list_header_id;
6849:

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

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

Line 6883: FROM ams_list_src_types a,

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

Line 6903: FROM ams_list_src_types a,

6899: l_source_col_name varchar2(1000);
6900:
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

Line 6913: FROM ams_list_src_types a,

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

Line 7856: FROM ams_list_src_types a

7852: l_action_rec AMS_ListAction_PVT.action_rec_type ;
7853: l_action_id number;
7854: cursor c_mapping_types(p_master_type varchar2) is
7855: SELECT list_source_type_id
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

Line 7862: from ams_list_src_types a,

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
7865: and b.sub_source_type_id = a.list_source_type_id;
7866:

Line 9428: from ams_list_src_types stypes, ams_list_headers_all list

9424:
9425:
9426: cursor c_remote_list is
9427: select nvl(stypes.remote_flag,'N') ,database_link
9428: from ams_list_src_types stypes, ams_list_headers_all list
9429: where list.list_source_type = stypes.source_type_code
9430: and list_header_id = p_list_header_id;
9431:
9432: l_list_selection varchar2(1);

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

9509: -- SOLIN, bug 4410333
9510: -- check whether datasource is enabled.
9511: cursor c_check_datasource(c_list_header_id NUMBER) is
9512: SELECT a.enabled_flag
9513: FROM ams_list_src_types a,
9514: ams_list_headers_all b
9515: WHERE a.source_type_code = b.list_source_type
9516: AND b.list_header_id = c_list_header_id;
9517:

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

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

Line 9550: FROM ams_list_src_types a,

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

Line 9571: FROM ams_list_src_types a,

9567: l_source_col_name varchar2(1000);
9568:
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

Line 9581: FROM ams_list_src_types a,

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

Line 10727: from ams_list_headers_all head, ams_list_src_types stypes

10723:
10724: l_list_header_id NUMBER;
10725: cursor c_migrate_list is
10726: select head.list_header_id
10727: from ams_list_headers_all head, ams_list_src_types stypes
10728: where head.status_code = 'AVAILABLE'
10729: and head.MIGRATION_DATE is NULL
10730: and head.list_source_type = stypes.source_type_code
10731: and stypes.remote_flag = 'Y';

Line 10775: from ams_list_src_types stypes, ams_list_headers_all list

10771:
10772:
10773: cursor c_dblink is
10774: select database_link
10775: from ams_list_src_types stypes, ams_list_headers_all list
10776: where list.list_source_type = stypes.source_type_code
10777: and list_header_id = p_list_header_id;
10778:
10779: begin

Line 12292: from ams_list_src_types

12288: l_view_tbl JTF_VARCHAR2_TABLE_100;
12289: l_source_col_dt_tbl JTF_VARCHAR2_TABLE_100;
12290: cursor c_master_source_type is
12291: select source_object_name , source_object_name || '.' || source_object_pk_field
12292: from ams_list_src_types
12293: where source_type_code = p_master_type;
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

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);

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

12654: cursor cur_primary_key_sql is
12655: SELECT lc.SOURCE_OBJECT_NAME, lc.SOURCE_OBJECT_PK_FIELD
12656: FROM ams_list_queries_all lq,
12657: ams_list_headers_all lh,
12658: ams_list_src_types lc
12659: WHERE lq.list_query_id = p_incl_object_id
12660: and lq.ARC_ACT_LIST_QUERY_USED_BY = 'LIST'
12661: and lq.ACT_LIST_QUERY_USED_BY_ID = lh.list_header_id
12662: and lc.source_type_code = lh.list_source_type;

Line 12993: ams_list_headers_all hdr, ams_list_src_types typ

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

Line 13002: select source_category from ams_list_src_types types, ams_list_headers_all head

12998: and used_in_list_entries = 'Y'
12999: and flds.tca_column_id = tca.ENTITY_COLUMN_ID;
13000:
13001: cursor c_data_type is
13002: select source_category from ams_list_src_types types, ams_list_headers_all head
13003: where head.list_header_id = p_list_header_id
13004: and head.list_source_type = types.source_type_code;
13005:
13006: l_prof VARCHAR2(50);

Line 14016: from ams_list_src_types stypes, ams_list_headers_all list

14012: cursor c_list_det is
14013: select stypes.database_link,
14014: list.remote_gen_flag,
14015: list.list_type
14016: from ams_list_src_types stypes, ams_list_headers_all list
14017: where list.list_source_type = stypes.source_type_code
14018: and list_header_id = p_list_header_id;
14019:
14020: cursor c_count_list_entries is