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_PULL dependencies on FND_PROFILE

Line 331: ||' where uom_class = FND_PROFILE.VALUE'||MSC_CL_PULL.v_dblink||'(''FM_YIELD_TYPE'')'

327: BEGIN
328: -- check if the UOM class is defined for the class in profile option-FM_YIELD_TYPE in source instance
329: v_sql_stmt := ' select uom_code '
330: ||' from mtl_units_of_measure'||MSC_CL_PULL.v_dblink
331: ||' where uom_class = FND_PROFILE.VALUE'||MSC_CL_PULL.v_dblink||'(''FM_YIELD_TYPE'')'
332: ||' and base_uom_flag = ''Y'' ';
333:
334: execute immediate v_sql_stmt into lv_uom_code;
335: v_temp_sql := v_temp_sql ||' x.CONV_FACTOR, ';

Line 427: ||' where uom_class = FND_PROFILE.VALUE'||MSC_CL_PULL.v_dblink||'(''FM_YIELD_TYPE'')'

423: BEGIN
424: -- check if the UOM class is defined for the class in profile option-FM_YIELD_TYPE in source instance
425: v_sql_stmt := ' select uom_code '
426: ||' from mtl_units_of_measure'||MSC_CL_PULL.v_dblink
427: ||' where uom_class = FND_PROFILE.VALUE'||MSC_CL_PULL.v_dblink||'(''FM_YIELD_TYPE'')'
428: ||' and base_uom_flag = ''Y'' ';
429:
430: execute immediate v_sql_stmt into lv_uom_code;
431: v_temp_sql := v_temp_sql ||' x.CONV_FACTOR, ';

Line 1538: lv_item_name := NVL(FND_PROFILE.VALUE('MSC_EAM_NO_ACTIVITY_ITEM'),'No Activity Item');

1534: and ((MSC_CL_PULL.v_org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (x.org_group = MSC_CL_PULL.v_org_group))
1535: );
1536: commit;
1537:
1538: lv_item_name := NVL(FND_PROFILE.VALUE('MSC_EAM_NO_ACTIVITY_ITEM'),'No Activity Item');
1539: insert into MSC_ST_SYSTEM_ITEMS (
1540: ORGANIZATION_ID,
1541: SR_INVENTORY_ITEM_ID,
1542: SR_INSTANCE_ID,

Line 1593: lv_item_name := NVL(FND_PROFILE.VALUE('MSC_WIP_NONSTD_JOB_ITEM'),'Non Standard Job Item');

1589: and org.ORGANIZATION_ID = x.ORGANIZATION_ID
1590: and ((MSC_CL_PULL.v_org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (org_group = MSC_CL_PULL.v_org_group));
1591:
1592: commit;
1593: lv_item_name := NVL(FND_PROFILE.VALUE('MSC_WIP_NONSTD_JOB_ITEM'),'Non Standard Job Item');
1594:
1595: insert into MSC_ST_SYSTEM_ITEMS (
1596: ORGANIZATION_ID,
1597: SR_INVENTORY_ITEM_ID,

Line 1671: lv_category_set_name := NVL(FND_PROFILE.VALUE('MSC_NO_ACTIVITY_ITEM_CATEGORY_SET'),'Unspecified Items');

1667: delete from MSC_ST_CATEGORY_SETS st_item_category_set
1668: where st_item_category_set.sr_instance_id = MSC_CL_PULL.v_instance_id
1669: and st_item_category_set.SR_CATEGORY_SET_ID = -5000;
1670: commit;
1671: lv_category_set_name := NVL(FND_PROFILE.VALUE('MSC_NO_ACTIVITY_ITEM_CATEGORY_SET'),'Unspecified Items');
1672: BEGIN
1673: lv_table_name:= 'MRP_AP_CATEGORY_SETS_V'||MSC_CL_PULL.v_dblink;
1674: lv_sql_stmt:= 'SELECT category_set_id FROM '||lv_table_name
1675: ||' WHERE category_set_name = '''||lv_category_set_name

Line 1724: lv_category_name := NVL(FND_PROFILE.VALUE('MSC_NO_ACTIVITY_ITEM_CATEGORY'),'NEW.MISC');

1720: and ((MSC_CL_PULL.v_org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (x.org_group = MSC_CL_PULL.v_org_group))
1721: );
1722: commit;
1723:
1724: lv_category_name := NVL(FND_PROFILE.VALUE('MSC_NO_ACTIVITY_ITEM_CATEGORY'),'NEW.MISC');
1725: BEGIN
1726: lv_table_name:= 'MRP_AP_ITEM_CATEGORIES_V'||MSC_CL_PULL.v_dblink;
1727: lv_sql_stmt:= 'SELECT category_id,description FROM ' ||lv_table_name
1728: || ' WHERE category_name = '''||lv_category_name