DBA Data[Home] [Help]

APPS.EGO_IMPORT_PVT dependencies on MTL_ITEM_CATALOG_GROUPS_B_KFV

Line 6148: FROM MTL_ITEM_CATALOG_GROUPS_B_KFV MICG

6144: ATTR.ENABLED_FLAG = 'Y' AND
6145: ATTR.ATTRIBUTE_NAME LIKE 'MTL_SYSTEM_ITEMS.DESCRIPTION')),
6146: NVL(ITEM_CATALOG_GROUP_ID,
6147: ( SELECT MICG.ITEM_CATALOG_GROUP_ID
6148: FROM MTL_ITEM_CATALOG_GROUPS_B_KFV MICG
6149: WHERE MICG.CONCATENATED_SEGMENTS = MSII.ITEM_CATALOG_GROUP_NAME)),
6150: CONFIRM_STATUS,
6151: NVL(REVISION_IMPORT_POLICY, l_batch_rev_policy),
6152: MSII.STYLE_ITEM_FLAG

Line 7377: FROM MTL_ITEM_CATALOG_GROUPS_B_KFV MICG

7373: -- update the item_catalog_group_id
7374: UPDATE
7375: MTL_SYSTEM_ITEMS_INTERFACE MSII
7376: SET ITEM_CATALOG_GROUP_ID = (SELECT MICG.ITEM_CATALOG_GROUP_ID
7377: FROM MTL_ITEM_CATALOG_GROUPS_B_KFV MICG
7378: WHERE MICG.CONCATENATED_SEGMENTS = MSII.ITEM_CATALOG_GROUP_NAME)
7379: WHERE MSII.SET_PROCESS_ID = p_data_set_id
7380: AND MSII.PROCESS_FLAG = 0
7381: AND MSII.ORGANIZATION_ID = l_org_id

Line 11904: FROM MTL_ITEM_CATALOG_GROUPS_B_KFV MICG

11900: WHERE MP.ORGANIZATION_CODE = MSII.ORGANIZATION_CODE))
11901: ,ITEM_CATALOG_GROUP_ID =
11902: NVL(ITEM_CATALOG_GROUP_ID,
11903: (SELECT MICG.ITEM_CATALOG_GROUP_ID
11904: FROM MTL_ITEM_CATALOG_GROUPS_B_KFV MICG
11905: WHERE MICG.CONCATENATED_SEGMENTS = MSII.ITEM_CATALOG_GROUP_NAME))
11906: WHERE SET_PROCESS_ID = p_batch_id
11907: AND SOURCE_SYSTEM_ID = p_src_system_id
11908: AND SOURCE_SYSTEM_REFERENCE = p_src_system_ref