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_ITEM_ODS_LOAD dependencies on MSC_CATEGORY_SET_ID_LID

Line 1059: FROM MSC_CATEGORY_SET_ID_LID mcsil,

1055: msic.START_DATE_ACTIVE,
1056: msic.END_DATE_ACTIVE,
1057: msic.SR_INSTANCE_ID,
1058: msic.SR_CATEGORY_ID
1059: FROM MSC_CATEGORY_SET_ID_LID mcsil,
1060: MSC_ITEM_ID_LID t1,
1061: MSC_ST_ITEM_CATEGORIES msic
1062: WHERE t1.SR_INVENTORY_ITEM_ID= msic.inventory_item_id
1063: AND t1.sr_instance_id= msic.sr_instance_id

Line 1076: FROM MSC_CATEGORY_SET_ID_LID mcsil,

1072: t1.INVENTORY_ITEM_ID,
1073: mcsil.Category_Set_ID,
1074: msic.SR_INSTANCE_ID,
1075: msic.SR_CATEGORY_ID
1076: FROM MSC_CATEGORY_SET_ID_LID mcsil,
1077: MSC_ITEM_ID_LID t1,
1078: MSC_ST_ITEM_CATEGORIES msic
1079: WHERE t1.SR_INVENTORY_ITEM_ID= msic.inventory_item_id
1080: AND t1.sr_instance_id= msic.sr_instance_id

Line 1179: ||' FROM MSC_CATEGORY_SET_ID_LID mcsil,'

1175: ||' :v_current_date , '
1176: ||' :v_current_user , '
1177: ||' :v_current_date , '
1178: ||' :v_current_user '
1179: ||' FROM MSC_CATEGORY_SET_ID_LID mcsil,'
1180: ||' MSC_ITEM_ID_LID t1,'
1181: ||' MSC_ST_ITEM_CATEGORIES msic'
1182: ||' WHERE t1.SR_INVENTORY_ITEM_ID = msic.inventory_item_id '
1183: ||' AND t1.sr_instance_id = msic.sr_instance_id '

Line 1475: FROM MSC_CATEGORY_SET_ID_LID mcsil,

1471: mscs.DESCRIPTION,
1472: mscs.CONTROL_LEVEL,
1473: mscs.DEFAULT_FLAG,
1474: mscs.SR_INSTANCE_ID
1475: FROM MSC_CATEGORY_SET_ID_LID mcsil,
1476: MSC_ST_CATEGORY_SETS mscs
1477: WHERE mcsil.SR_Category_Set_ID= mscs.SR_Category_Set_ID
1478: AND mcsil.SR_Instance_ID= mscs.SR_Instance_ID
1479: AND mscs.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

Line 1547: where table_name ='MSC_CATEGORY_SET_ID_LID';

1543: begin
1544: select num_rows,decode (stale_stats,'NO', MSC_UTIL.SYS_NO, MSC_UTIL.SYS_YES )
1545: into lv_cat_id_count, lv_cat_stat_stale
1546: from dba_TAB_STATISTICS
1547: where table_name ='MSC_CATEGORY_SET_ID_LID';
1548: exception when no_data_found then
1549: lv_cat_stat_stale := MSC_UTIL.SYS_YES ;
1550: end;
1551:

Line 1560: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;

1556: IF lv_control_flag = 2 THEN
1557:
1558: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1559: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1560: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1561: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= -1;
1562: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= -1;
1563: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1564: lv_cat_stat_stale := MSC_UTIL.SYS_YES;

Line 1562: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= -1;

1558: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1559: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1560: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1561: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= -1;
1562: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= -1;
1563: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1564: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1565: END IF;
1566:

Line 1571: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_CATEGORY_SET_ID_LID');

1567: ELSE
1568:
1569: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1570: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_ITEM_ID_LID');
1571: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_CATEGORY_SET_ID_LID');
1572: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1573: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1574: END IF;
1575:

Line 1588: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;

1584: IF (MSC_CL_COLLECTION.v_coll_prec.item_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.org_group_flag =MSC_UTIL.G_ALL_ORGANIZATIONS ) THEN
1585:
1586: IF lv_control_flag = 2 THEN
1587: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1588: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1589: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= -1;
1590: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= -1;
1591: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1592: lv_cat_stat_stale := MSC_UTIL.SYS_YES;

Line 1590: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= -1;

1586: IF lv_control_flag = 2 THEN
1587: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1588: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1589: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= -1;
1590: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= -1;
1591: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1592: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1593: ELSE
1594: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_ITEM_ID_LID');

Line 1595: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_CATEGORY_SET_ID_LID');

1591: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1592: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1593: ELSE
1594: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_ITEM_ID_LID');
1595: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_CATEGORY_SET_ID_LID');
1596: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1597: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1598: END IF;
1599:

Line 1614: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;

1610: (MSC_CL_COLLECTION.v_coll_prec.item_sn_flag = MSC_UTIL.SYS_TGT) and (MSC_CL_COLLECTION.v_coll_prec.org_group_flag=MSC_UTIL.G_ALL_ORGANIZATIONS) THEN
1611:
1612: IF lv_control_flag = 2 THEN
1613: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1614: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1615: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= -1;
1616: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= -1;
1617: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1618: lv_cat_stat_stale := MSC_UTIL.SYS_YES;

Line 1616: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= -1;

1612: IF lv_control_flag = 2 THEN
1613: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1614: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1615: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= -1;
1616: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= -1;
1617: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1618: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1619: ELSE
1620: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_ITEM_ID_LID');

Line 1621: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_CATEGORY_SET_ID_LID');

1617: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1618: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1619: ELSE
1620: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_ITEM_ID_LID');
1621: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_CATEGORY_SET_ID_LID');
1622: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1623: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1624: END IF;
1625:

Line 1826: INSERT INTO MSC_CATEGORY_SET_ID_LID

1822: END LOOP;
1823:
1824: COMMIT;
1825:
1826: INSERT INTO MSC_CATEGORY_SET_ID_LID
1827: ( SR_Category_Set_ID,
1828: SR_INSTANCE_ID,
1829: Category_Set_ID)
1830: SELECT distinct

Line 1837: from MSC_CATEGORY_SET_ID_LID mcsil

1833: mcs.Category_Set_ID
1834: FROM MSC_ST_CATEGORY_SETS mscs,
1835: MSC_CATEGORY_SETS mcs
1836: WHERE NOT EXISTS( select 1
1837: from MSC_CATEGORY_SET_ID_LID mcsil
1838: where mscs.SR_Category_Set_ID= mcsil.SR_Category_Set_ID
1839: and mscs.SR_INSTANCE_ID= mcsil.SR_INSTANCE_ID)
1840: AND mscs.Category_Set_NAME= mcs.Category_Set_NAME
1841: AND mscs.SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id;

Line 1943: msc_analyse_tables_pk.analyse_table( 'MSC_CATEGORY_SET_ID_LID');

1939: IF lv_items_stat_stale = MSC_UTIL.SYS_YES THEN
1940: msc_analyse_tables_pk.analyse_table( 'MSC_ITEM_ID_LID');
1941: END IF;
1942: IF lv_cat_stat_stale = MSC_UTIL.SYS_YES THEN
1943: msc_analyse_tables_pk.analyse_table( 'MSC_CATEGORY_SET_ID_LID');
1944: END IF;
1945: END IF;
1946:
1947: EXCEPTION