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_SCE_LOADS_PKG dependencies on AD_DDL

Line 10481: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

10477:
10478:
10479: PROCEDURE create_index (v_applsys_schema IN VARCHAR2) IS
10480: BEGIN
10481: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
10482: application_short_name => 'MSC',
10483: statement_type => AD_DDL.CREATE_INDEX,
10484: statement =>
10485: 'create index MSC_ST_SERIAL_NUMBER_N1'

Line 10483: statement_type => AD_DDL.CREATE_INDEX,

10479: PROCEDURE create_index (v_applsys_schema IN VARCHAR2) IS
10480: BEGIN
10481: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
10482: application_short_name => 'MSC',
10483: statement_type => AD_DDL.CREATE_INDEX,
10484: statement =>
10485: 'create index MSC_ST_SERIAL_NUMBER_N1'
10486: ||' on MSC_ST_SERIAL_NUMBERS '
10487: ||'(publisher_company,publisher_site,publisher_item_name,master_item_name,order_type) '

Line 10499: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

10495:
10496:
10497: PROCEDURE drop_index(v_applsys_schema IN VARCHAR2) IS
10498: BEGIN
10499: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
10500: application_short_name => 'MSC',
10501: statement_type => AD_DDL.DROP_INDEX,
10502: statement =>
10503: 'drop index MSC_ST_SERIAL_NUMBER_N1',

Line 10501: statement_type => AD_DDL.DROP_INDEX,

10497: PROCEDURE drop_index(v_applsys_schema IN VARCHAR2) IS
10498: BEGIN
10499: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
10500: application_short_name => 'MSC',
10501: statement_type => AD_DDL.DROP_INDEX,
10502: statement =>
10503: 'drop index MSC_ST_SERIAL_NUMBER_N1',
10504: object_name =>'MSC_ST_SERIAL_NUMBER_N1'
10505: );