APPS.CZ_IMP_SINGLE dependencies on CZ_EXV_ITEM_TYPES

Line 2027: FROM CZ_EXV_ITEM_TYPES

2023: FORALL i IN 1..itemCatalogGroupId.COUNT
2024: INSERT INTO CZ_IMP_ITEM_TYPE
2025: (DESC_TEXT, NAME, ORIG_SYS_REF,SRC_APPLICATION_ID,RUN_ID)
2026: SELECT DESCRIPTION, CATALOG_CONCAT_SEGS, ITEM_CATALOG_GROUP_ID, G_BOM_APPLICATION_ID, inRUN_ID
2027: FROM CZ_EXV_ITEM_TYPES
2028: WHERE ITEM_CATALOG_GROUP_ID = itemCatalogGroupId(i);
2029: ELSE
2030: FORALL i IN 1..itemCatalogGroupId.COUNT
2031: INSERT INTO CZ_IMP_ITEM_TYPE

Line 2034: FROM CZ_EXV_ITEM_TYPES

2030: FORALL i IN 1..itemCatalogGroupId.COUNT
2031: INSERT INTO CZ_IMP_ITEM_TYPE
2032: (DESC_TEXT, NAME, ORIG_SYS_REF, SRC_APPLICATION_ID, RUN_ID)
2033: SELECT DESCRIPTION, DESCRIPTION, ITEM_CATALOG_GROUP_ID, G_BOM_APPLICATION_ID, inRUN_ID
2034: FROM CZ_EXV_ITEM_TYPES
2035: WHERE ITEM_CATALOG_GROUP_ID = itemCatalogGroupId(i);
2036: END IF;
2037:
2038: if (CZ_IMP_ALL.get_time) then

Line 2212: FROM CZ_EXV_ITEM_TYPES

2208: LOOP
2209: l_item_catalog_path := '';
2210:
2211: FOR i IN(SELECT item_catalog_group_id,parent_catalog_group_id,description,catalog_concat_segs
2212: FROM CZ_EXV_ITEM_TYPES
2213: START WITH item_catalog_group_id = itemCatalogGroupId(item_index)
2214: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id)
2215: LOOP
2216: l_prev_item_catalog_tbl.extend;