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_CL_BOM_PULL dependencies on MSC_ST_BOM_COMPONENTS

Line 41: MSC_CL_PULL.v_table_name:= 'MSC_ST_BOM_COMPONENTS';

37:
38: --=================== Net Change Mode: Delete ==================
39: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
40:
41: MSC_CL_PULL.v_table_name:= 'MSC_ST_BOM_COMPONENTS';
42: MSC_CL_PULL.v_view_name := 'MRP_AD_BOM_COMPONENTS_V';
43:
44: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
45: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

Line 51: ' insert into MSC_ST_BOM_COMPONENTS'

47: v_temp_sql := NULL;
48: END IF;
49:
50: v_sql_stmt:=
51: ' insert into MSC_ST_BOM_COMPONENTS'
52: ||'( COMPONENT_SEQUENCE_ID,'
53: ||' BILL_SEQUENCE_ID,'
54: ||' DELETED_FLAG,'
55: ||' REFRESH_ID,'

Line 74: MSC_CL_PULL.v_table_name:= 'MSC_ST_BOM_COMPONENTS';

70: COMMIT;
71:
72: END IF;
73:
74: MSC_CL_PULL.v_table_name:= 'MSC_ST_BOM_COMPONENTS';
75:
76:
77:
78: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

Line 263: ' insert into MSC_ST_BOM_COMPONENTS'

259: v_union_sql := ' ';
260:
261: END IF;
262: v_sql_stmt:=
263: ' insert into MSC_ST_BOM_COMPONENTS'
264: ||'( COMPONENT_SEQUENCE_ID,'
265: ||' INVENTORY_ITEM_ID,'
266: ||' BILL_SEQUENCE_ID,'
267: ||' OPERATION_SEQ_NUM,'

Line 713: 'create index MSC_ST_BOM_COMPONENTS_'||lv_icode

709: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
710: application_short_name => 'MSC',
711: statement_type => AD_DDL.CREATE_INDEX,
712: statement =>
713: 'create index MSC_ST_BOM_COMPONENTS_'||lv_icode
714: ||' ON MSC_ST_BOM_COMPONENTS (BILL_SEQUENCE_ID,SR_INSTANCE_ID) '
715: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
716: object_name => 'MSC_ST_BOM_COMPONENTS_'||lv_icode);
717:

Line 714: ||' ON MSC_ST_BOM_COMPONENTS (BILL_SEQUENCE_ID,SR_INSTANCE_ID) '

710: application_short_name => 'MSC',
711: statement_type => AD_DDL.CREATE_INDEX,
712: statement =>
713: 'create index MSC_ST_BOM_COMPONENTS_'||lv_icode
714: ||' ON MSC_ST_BOM_COMPONENTS (BILL_SEQUENCE_ID,SR_INSTANCE_ID) '
715: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
716: object_name => 'MSC_ST_BOM_COMPONENTS_'||lv_icode);
717:
718: EXCEPTION

Line 716: object_name => 'MSC_ST_BOM_COMPONENTS_'||lv_icode);

712: statement =>
713: 'create index MSC_ST_BOM_COMPONENTS_'||lv_icode
714: ||' ON MSC_ST_BOM_COMPONENTS (BILL_SEQUENCE_ID,SR_INSTANCE_ID) '
715: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
716: object_name => 'MSC_ST_BOM_COMPONENTS_'||lv_icode);
717:
718: EXCEPTION
719: WHEN OTHERS THEN
720: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 723: msc_analyse_tables_pk.analyse_table( 'MSC_ST_BOM_COMPONENTS');

719: WHEN OTHERS THEN
720: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
721:
722: END;
723: msc_analyse_tables_pk.analyse_table( 'MSC_ST_BOM_COMPONENTS');
724:
725: LOAD_CO_PRODUCT_BOMS;
726:
727: BEGIN

Line 732: 'drop index MSC_ST_BOM_COMPONENTS_'||lv_icode,

728: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
729: application_short_name => 'MSC',
730: statement_type => AD_DDL.DROP_INDEX,
731: statement =>
732: 'drop index MSC_ST_BOM_COMPONENTS_'||lv_icode,
733: object_name => 'MSC_ST_BOM_COMPONENTS_'||lv_icode);
734: EXCEPTION
735: WHEN OTHERS THEN
736: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 733: object_name => 'MSC_ST_BOM_COMPONENTS_'||lv_icode);

729: application_short_name => 'MSC',
730: statement_type => AD_DDL.DROP_INDEX,
731: statement =>
732: 'drop index MSC_ST_BOM_COMPONENTS_'||lv_icode,
733: object_name => 'MSC_ST_BOM_COMPONENTS_'||lv_icode);
734: EXCEPTION
735: WHEN OTHERS THEN
736: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
737:

Line 2626: 'update MSC_ST_BOM_COMPONENTS x

2622: /* set the primary_flag for the actual component to "not a primary" */
2623:
2624: v_query_str4 :=
2625:
2626: 'update MSC_ST_BOM_COMPONENTS x
2627: set x.primary_flag = 2
2628: WHERE x.bill_Sequence_id='||l_BILL_SEQuence_ID ||
2629: ' and x.primary_flag is null
2630: and nvl(x.component_type,0) != 10

Line 2639: insert into MSC_ST_BOM_COMPONENTS

2635:
2636: EXECUTE IMMEDIATE v_query_str4;
2637:
2638:
2639: insert into MSC_ST_BOM_COMPONENTS
2640: ( COMPONENT_SEQUENCE_ID,
2641: INVENTORY_ITEM_ID,
2642: BILL_SEQUENCE_ID,
2643: OPERATION_SEQ_NUM,

Line 2697: from MSC_ST_BOM_COMPONENTS x

2693: refresh_id,
2694: sr_instance_id,
2695: v_primary_flag,
2696: 3
2697: from MSC_ST_BOM_COMPONENTS x
2698: WHERE x.bill_Sequence_id = l_BILL_SEQuence_ID
2699: and x.sr_instance_id = MSC_CL_PULL.v_instance_id
2700: and rownum = 1;
2701: