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.MSC_IMPORT_UTIL dependencies on MSC_CRITERIA

Line 126: msc_criteria where

122: procedure init is
123:
124: cursor c_lov_type(l_field_name varchar2) is
125: select lov_type,sql_statement from
126: msc_criteria where
127: folder_object in ('MSC_IMM_UPDATE_ATTRIBUTES',
128: 'MSC_REGION_UPDATE_ATTRIBUTES',
129: 'MSC_CUST_UPDATE_ATTRIBUTES',
130: 'MSC_IMM_DESTINATION_ATTRIBUTES'

Line 136: msc_criteria where

132: and field_name = l_field_name;
133:
134: cursor c_lov_type_count(l_field_name varchar2) is
135: select count(*) from
136: msc_criteria where
137: folder_object in ('MSC_IMM_UPDATE_ATTRIBUTES',
138: 'MSC_REGION_UPDATE_ATTRIBUTES',
139: 'MSC_CUST_UPDATE_ATTRIBUTES',
140: 'MSC_IMM_DESTINATION_ATTRIBUTES')

Line 425: from msc_criteria

421:
422: cursor c_chk_attr(p_folder_object in varchar2,
423: p_attr_name in varchar2) is
424: select 1
425: from msc_criteria
426: where folder_object = p_folder_object
427: and field_name = p_attr_name;
428:
429: cursor c_get_dest_rowid_cust(l_simset_id number,l_item_id number,l_org_id number,

Line 777: msc_criteria where

773:
774: procedure get_sql(p_attr_name varchar2,p_sql out nocopy varchar2,p_lov_type out nocopy number) is
775: cursor c_sql is
776: select sql_statement,lov_type from
777: msc_criteria where
778: folder_object in ('MSC_IMM_UPDATE_ATTRIBUTES',
779: 'MSC_REGION_UPDATE_ATTRIBUTES',
780: 'MSC_CUST_UPDATE_ATTRIBUTES',
781: 'MSC_IMM_DESTINATION_ATTRIBUTES'