[Home] [Help]
2637: FORALL i IN 1..itemCatalogGroupId.COUNT
2638: INSERT INTO CZ_IMP_PROPERTY
2639: (DESC_TEXT,NAME,ORIG_SYS_REF,RUN_ID,DATA_TYPE,SRC_APPLICATION_ID)
2640: SELECT DESCRIPTION, ELEMENT_NAME, ELEMENT_NAME, inRUN_ID, TEXT_TYPE, G_BOM_APPLICATION_ID
2641: FROM CZ_EXV_ITEM_PROPERTIES
2642: WHERE ITEM_CATALOG_GROUP_ID = itemCatalogGroupId(i);
2643:
2644: if (CZ_IMP_ALL.get_time) then
2645: end_time := dbms_utility.get_time();
2777: (FSK_ITEMTYPE_1_1,FSK_ITEMTYPE_1_EXT,FSK_PROPERTY_2_1,FSK_PROPERTY_2_EXT,RUN_ID,
2778: ORIG_SYS_REF,SRC_APPLICATION_ID)
2779: SELECT ITEM_CATALOG_GROUP_ID, ITEM_CATALOG_GROUP_ID, ELEMENT_NAME, ELEMENT_NAME, inRUN_ID,
2780: TO_CHAR(ITEM_CATALOG_GROUP_ID) || ':' || ELEMENT_NAME, G_BOM_APPLICATION_ID
2781: FROM CZ_EXV_ITEM_PROPERTIES
2782: WHERE ITEM_CATALOG_GROUP_ID = itemCatalogGroupId(i);
2783:
2784: if (CZ_IMP_ALL.get_time) then
2785: end_time := dbms_utility.get_time();