DBA Data[Home] [Help]

APPS.CZ_IMP_SINGLE dependencies on CZ_EXV_ITEM_PROPERTIES

Line 2711: FROM CZ_EXV_ITEM_PROPERTIES

2707: FORALL i IN 1..itemCatalogGroupId.COUNT
2708: INSERT INTO CZ_IMP_PROPERTY
2709: (DESC_TEXT,NAME,ORIG_SYS_REF,RUN_ID,DATA_TYPE,SRC_APPLICATION_ID)
2710: SELECT DESCRIPTION, ELEMENT_NAME, ELEMENT_NAME, inRUN_ID, TEXT_TYPE, G_BOM_APPLICATION_ID
2711: FROM CZ_EXV_ITEM_PROPERTIES
2712: WHERE ITEM_CATALOG_GROUP_ID = itemCatalogGroupId(i);
2713:
2714: if (CZ_IMP_ALL.get_time) then
2715: end_time := dbms_utility.get_time();

Line 2851: FROM CZ_EXV_ITEM_PROPERTIES

2847: (FSK_ITEMTYPE_1_1,FSK_ITEMTYPE_1_EXT,FSK_PROPERTY_2_1,FSK_PROPERTY_2_EXT,RUN_ID,
2848: ORIG_SYS_REF,SRC_APPLICATION_ID)
2849: SELECT ITEM_CATALOG_GROUP_ID, ITEM_CATALOG_GROUP_ID, ELEMENT_NAME, ELEMENT_NAME, inRUN_ID,
2850: TO_CHAR(ITEM_CATALOG_GROUP_ID) || ':' || ELEMENT_NAME, G_BOM_APPLICATION_ID
2851: FROM CZ_EXV_ITEM_PROPERTIES
2852: WHERE ITEM_CATALOG_GROUP_ID = itemCatalogGroupId(i);
2853:
2854: if (CZ_IMP_ALL.get_time) then
2855: end_time := dbms_utility.get_time();