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.EGO_ICC_BULKLOAD_PVT dependencies on MTL_ITEM_CATALOG_GROUPS_KFV

Line 999: from mtl_item_catalog_groups_kfv icc_kfv

995: --- ICC table , ICC Name
996:
997: UPDATE mtl_item_cat_grps_interface micgi
998: SET item_catalog_name = ( select icc_kfv.concatenated_segments
999: from mtl_item_catalog_groups_kfv icc_kfv
1000: where icc_kfv.item_catalog_group_id = micgi.item_catalog_group_id
1001: )
1002: WHERE micgi.item_catalog_group_id IS NOT NULL
1003: AND micgi.process_status = G_PROCESS_STATUS_INITIAL

Line 1017: from mtl_item_catalog_groups_kfv icc_kfv

1013:
1014:
1015: UPDATE mtl_item_cat_grps_interface micgi
1016: SET micgi.item_catalog_group_id = ( select icc_kfv.item_catalog_group_id
1017: from mtl_item_catalog_groups_kfv icc_kfv
1018: where icc_kfv.concatenated_segments = micgi.item_catalog_name
1019: )
1020: WHERE micgi.item_catalog_name IS NOT NULL
1021: AND micgi.item_catalog_group_id IS NULL

Line 1117: from mtl_item_catalog_groups_kfv icc_kfv

1113: /*****************************************/
1114:
1115: UPDATE mtl_item_cat_grps_interface micgi
1116: SET parent_catalog_group_name = ( select icc_kfv.concatenated_segments
1117: from mtl_item_catalog_groups_kfv icc_kfv
1118: where icc_kfv.item_catalog_group_id = micgi.parent_catalog_group_id
1119: )
1120: WHERE micgi.parent_catalog_group_id IS NOT NULL
1121: AND micgi.process_status = G_PROCESS_STATUS_INITIAL

Line 1133: from mtl_item_catalog_groups_kfv icc_kfv

1129: write_debug (l_proc_name, '6');
1130:
1131: UPDATE mtl_item_cat_grps_interface micgi
1132: SET micgi.parent_catalog_group_id = ( select icc_kfv.item_catalog_group_id
1133: from mtl_item_catalog_groups_kfv icc_kfv
1134: where icc_kfv.concatenated_segments = micgi.parent_catalog_group_name
1135: )
1136: WHERE micgi.parent_catalog_group_name IS NOT NULL
1137: AND micgi.parent_catalog_group_id IS NULL

Line 1272: from mtl_item_catalog_groups_kfv icc_kfv

1268: --- Update AG table, ICC Name
1269: ---
1270: UPDATE EGO_ATTR_GRPS_ASSOC_INTERFACE EAGAI
1271: SET eagai.item_catalog_name = ( select icc_kfv.concatenated_segments
1272: from mtl_item_catalog_groups_kfv icc_kfv
1273: where icc_kfv.item_catalog_group_id = eagai.item_catalog_group_id
1274: )
1275: WHERE eagai.item_catalog_group_id IS NOT NULL
1276: AND eagai.process_status = G_PROCESS_STATUS_INITIAL

Line 1289: from mtl_item_catalog_groups_kfv icc_kfv

1285:
1286: ---Update AG table, ICC id
1287: UPDATE EGO_ATTR_GRPS_ASSOC_INTERFACE EAGAI
1288: SET eagai.item_catalog_group_id = ( select icc_kfv.item_catalog_group_id
1289: from mtl_item_catalog_groups_kfv icc_kfv
1290: where icc_kfv.concatenated_segments = eagai.item_catalog_name
1291: )
1292: WHERE eagai.item_catalog_name IS NOT NULL
1293: AND eagai.item_catalog_group_id IS NULL

Line 1450: from mtl_item_catalog_groups_kfv icc_kfv

1446:
1447: --- ICC Name
1448: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE efpmi
1449: SET efpmi.item_catalog_name = ( select icc_kfv.concatenated_segments
1450: from mtl_item_catalog_groups_kfv icc_kfv
1451: where icc_kfv.item_catalog_group_id = efpmi.item_catalog_group_id
1452: )
1453: WHERE efpmi.item_catalog_group_id IS NOT NULL
1454: AND efpmi.process_status = G_PROCESS_STATUS_INITIAL

Line 1468: from mtl_item_catalog_groups_kfv icc_kfv

1464: -- ICC id
1465:
1466: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE efpmi
1467: SET efpmi.item_catalog_group_id = ( select icc_kfv.item_catalog_group_id
1468: from mtl_item_catalog_groups_kfv icc_kfv
1469: where icc_kfv.concatenated_segments = efpmi.item_catalog_name
1470: )
1471: WHERE efpmi.item_catalog_name IS NOT NULL
1472: AND efpmi.item_catalog_group_id IS NULL

Line 1991: from mtl_item_catalog_groups_kfv icc_kfv

1987: --- ICC versions table , ICC Name
1988:
1989: UPDATE EGO_ICC_VERS_INTERFACE eivi
1990: SET eivi.item_catalog_name = ( select icc_kfv.concatenated_segments
1991: from mtl_item_catalog_groups_kfv icc_kfv
1992: where icc_kfv.item_catalog_group_id = eivi.item_catalog_group_id
1993: )
1994: WHERE eivi.item_catalog_group_id IS NOT NULL
1995: AND eivi.process_status = G_PROCESS_STATUS_INITIAL

Line 2007: from mtl_item_catalog_groups_kfv icc_kfv

2003: write_debug(l_proc_name, 'updated name');
2004:
2005: UPDATE ego_icc_vers_interface eivi
2006: SET eivi.item_catalog_group_id = ( select icc_kfv.item_catalog_group_id
2007: from mtl_item_catalog_groups_kfv icc_kfv
2008: where icc_kfv.concatenated_segments = eivi.item_catalog_name
2009: )
2010: WHERE eivi.item_catalog_name IS NOT NULL
2011: AND eivi.item_catalog_group_id IS NULL

Line 6591: from mtl_item_catalog_groups_kfv icc_kfv

6587:
6588: write_debug(l_proc_name, 'updating name');
6589: UPDATE EGO_ICC_VERS_INTERFACE eivi
6590: SET eivi.item_catalog_name = ( select icc_kfv.concatenated_segments
6591: from mtl_item_catalog_groups_kfv icc_kfv
6592: where icc_kfv.item_catalog_group_id = eivi.item_catalog_group_id
6593: )
6594: WHERE eivi.item_catalog_group_id = p_icc_id
6595: AND eivi.process_status = G_PROCESS_STATUS_INITIAL

Line 6609: from mtl_item_catalog_groups_kfv icc_kfv

6605: write_debug(l_proc_name, 'updating id');
6606:
6607: UPDATE ego_icc_vers_interface eivi
6608: SET eivi.item_catalog_group_id = ( select icc_kfv.item_catalog_group_id
6609: from mtl_item_catalog_groups_kfv icc_kfv
6610: where icc_kfv.concatenated_segments = eivi.item_catalog_name
6611: )
6612: WHERE eivi.item_catalog_name = P_ICC_NAME
6613: AND eivi.item_catalog_group_id IS NULL