DBA Data[Home] [Help]

APPS.EGO_IMPORT_PVT dependencies on MTL_ITEM_CATALOG_GROUPS_B_KFV

Line 6230: FROM MTL_ITEM_CATALOG_GROUPS_B_KFV MICG

6226: ATTR.ENABLED_FLAG = 'Y' AND
6227: ATTR.ATTRIBUTE_NAME LIKE 'MTL_SYSTEM_ITEMS.DESCRIPTION')),
6228: NVL(ITEM_CATALOG_GROUP_ID,
6229: ( SELECT MICG.ITEM_CATALOG_GROUP_ID
6230: FROM MTL_ITEM_CATALOG_GROUPS_B_KFV MICG
6231: WHERE MICG.CONCATENATED_SEGMENTS = MSII.ITEM_CATALOG_GROUP_NAME)),
6232: CONFIRM_STATUS,
6233: NVL(REVISION_IMPORT_POLICY, l_batch_rev_policy),
6234: MSII.STYLE_ITEM_FLAG

Line 7471: FROM MTL_ITEM_CATALOG_GROUPS_B_KFV MICG

7467: -- update the item_catalog_group_id
7468: UPDATE
7469: MTL_SYSTEM_ITEMS_INTERFACE MSII
7470: SET ITEM_CATALOG_GROUP_ID = (SELECT MICG.ITEM_CATALOG_GROUP_ID
7471: FROM MTL_ITEM_CATALOG_GROUPS_B_KFV MICG
7472: WHERE MICG.CONCATENATED_SEGMENTS = MSII.ITEM_CATALOG_GROUP_NAME)
7473: WHERE MSII.SET_PROCESS_ID = p_data_set_id
7474: AND MSII.PROCESS_FLAG = 0
7475: AND MSII.ORGANIZATION_ID = l_org_id

Line 12007: FROM MTL_ITEM_CATALOG_GROUPS_B_KFV MICG

12003: WHERE MP.ORGANIZATION_CODE = MSII.ORGANIZATION_CODE))
12004: ,ITEM_CATALOG_GROUP_ID =
12005: NVL(ITEM_CATALOG_GROUP_ID,
12006: (SELECT MICG.ITEM_CATALOG_GROUP_ID
12007: FROM MTL_ITEM_CATALOG_GROUPS_B_KFV MICG
12008: WHERE MICG.CONCATENATED_SEGMENTS = MSII.ITEM_CATALOG_GROUP_NAME))
12009: WHERE SET_PROCESS_ID = p_batch_id
12010: AND SOURCE_SYSTEM_ID = p_src_system_id
12011: AND SOURCE_SYSTEM_REFERENCE = p_src_system_ref