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 1062: FROM MSC_CATEGORY_SET_ID_LID mcsil,

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

Line 1079: FROM MSC_CATEGORY_SET_ID_LID mcsil,

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

Line 1182: ||' FROM MSC_CATEGORY_SET_ID_LID mcsil,'

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

Line 1478: FROM MSC_CATEGORY_SET_ID_LID mcsil,

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

Line 1551: where table_name ='MSC_CATEGORY_SET_ID_LID';

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

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

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

Line 1566: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= -1;

1562: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1563: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1564: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1565: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= -1;
1566: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= -1;
1567: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1568: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1569: END IF;
1570:

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

1571: ELSE
1572:
1573: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1574: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_ITEM_ID_LID');
1575: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_CATEGORY_SET_ID_LID');
1576: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1577: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1578: END IF;
1579:

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

1588: 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
1589:
1590: IF lv_control_flag = 2 THEN
1591: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1592: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1593: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= -1;
1594: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= -1;
1595: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1596: lv_cat_stat_stale := MSC_UTIL.SYS_YES;

Line 1594: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= -1;

1590: IF lv_control_flag = 2 THEN
1591: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1592: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1593: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= -1;
1594: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= -1;
1595: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1596: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1597: ELSE
1598: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_ITEM_ID_LID');

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

1595: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1596: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1597: ELSE
1598: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_ITEM_ID_LID');
1599: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_CATEGORY_SET_ID_LID');
1600: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1601: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1602: END IF;
1603:

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

1614: (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
1615:
1616: IF lv_control_flag = 2 THEN
1617: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1618: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1619: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= -1;
1620: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= -1;
1621: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1622: lv_cat_stat_stale := MSC_UTIL.SYS_YES;

Line 1620: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= -1;

1616: IF lv_control_flag = 2 THEN
1617: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1618: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1619: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= -1;
1620: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= -1;
1621: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1622: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1623: ELSE
1624: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_ITEM_ID_LID');

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

1621: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1622: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1623: ELSE
1624: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_ITEM_ID_LID');
1625: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_CATEGORY_SET_ID_LID');
1626: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1627: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1628: END IF;
1629:

Line 1830: INSERT INTO MSC_CATEGORY_SET_ID_LID

1826: END LOOP;
1827:
1828: COMMIT;
1829:
1830: INSERT INTO MSC_CATEGORY_SET_ID_LID
1831: ( SR_Category_Set_ID,
1832: SR_INSTANCE_ID,
1833: Category_Set_ID)
1834: SELECT distinct

Line 1841: from MSC_CATEGORY_SET_ID_LID mcsil

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

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

1943: IF lv_items_stat_stale = MSC_UTIL.SYS_YES THEN
1944: msc_analyse_tables_pk.analyse_table( 'MSC_ITEM_ID_LID');
1945: END IF;
1946: IF lv_cat_stat_stale = MSC_UTIL.SYS_YES THEN
1947: msc_analyse_tables_pk.analyse_table( 'MSC_CATEGORY_SET_ID_LID');
1948: END IF;
1949: END IF;
1950:
1951: EXCEPTION