APPS.CZ_IMP_SINGLE dependencies on CZ_EXV_ITEM_TYPES

Line 1965: FROM CZ_EXV_ITEM_TYPES

1961: FORALL i IN 1..itemCatalogGroupId.COUNT
1962: INSERT INTO CZ_IMP_ITEM_TYPE
1963: (DESC_TEXT, NAME, ORIG_SYS_REF,SRC_APPLICATION_ID,RUN_ID)
1964: SELECT DESCRIPTION, CATALOG_CONCAT_SEGS, ITEM_CATALOG_GROUP_ID, G_BOM_APPLICATION_ID, inRUN_ID
1965: FROM CZ_EXV_ITEM_TYPES
1966: WHERE ITEM_CATALOG_GROUP_ID = itemCatalogGroupId(i);
1967: ELSE
1968: FORALL i IN 1..itemCatalogGroupId.COUNT
1969: INSERT INTO CZ_IMP_ITEM_TYPE

Line 1972: FROM CZ_EXV_ITEM_TYPES

1968: FORALL i IN 1..itemCatalogGroupId.COUNT
1969: INSERT INTO CZ_IMP_ITEM_TYPE
1970: (DESC_TEXT, NAME, ORIG_SYS_REF, SRC_APPLICATION_ID, RUN_ID)
1971: SELECT DESCRIPTION, DESCRIPTION, ITEM_CATALOG_GROUP_ID, G_BOM_APPLICATION_ID, inRUN_ID
1972: FROM CZ_EXV_ITEM_TYPES
1973: WHERE ITEM_CATALOG_GROUP_ID = itemCatalogGroupId(i);
1974: END IF;
1975:
1976: if (CZ_IMP_ALL.get_time) then

Line 2150: FROM CZ_EXV_ITEM_TYPES

2146: LOOP
2147: l_item_catalog_path := '';
2148:
2149: FOR i IN(SELECT item_catalog_group_id,parent_catalog_group_id,description,catalog_concat_segs
2150: FROM CZ_EXV_ITEM_TYPES
2151: START WITH item_catalog_group_id = itemCatalogGroupId(item_index)
2152: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id)
2153: LOOP
2154: l_prev_item_catalog_tbl.extend;