INV Item relationships listing

Description
Categories: BI Publisher
Application: Inventory
Source: Item relationships listing (XML)
Short Name: INVIRRIT_XML
DB package: INV_INVIRRIT_XMLP_PKG
SELECT 
    &P_ITEM_FLEXDATA1               ITEM_FLEXDATA1, 
  MRI.INVENTORY_ITEM_ID         ITEM_ID1, 
  MSI1.DESCRIPTION              ITEM_SHORT_DESC1,
  MSI1.UNIT_OF_ISSUE            ITEM_UOI1,
    &P_CATG_FLEXDATA1            CATG_FLEXDATA1,
  MCAT1.CATEGORY_ID                CATG_ID1,
  MSI1.ITEM_CATALOG_GROUP_ID    ITEM_ICG1,
    &P_ITEM_FLEXDATA2             ITEM_FLEXDATA2,   
  MRI.RELATED_ITEM_ID           ITEM_ID2,
  MSI2.DESCRIPTION              ITEM_SHORT_DESC2,
  MSI2.UNIT_OF_ISSUE            ITEM_UOI2,
  MSI2.ITEM_CATALOG_GROUP_ID    ITEM_ICG2,
  MCATS2.STRUCTURE_ID            CATG_STRUCT_ID2,
    &P_CATG_FLEXDATA2                CATG_FLEXDATA2,
  MCAT2.CATEGORY_ID              CATG_ID2,
  MRI.RECIPROCAL_FLAG          RECIPROCAL_FLAG, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_item_value1', 'INV', 'MSTK', 101, MSI1.ORGANIZATION_ID, MSI1.INVENTORY_ITEM_ID, 'ALL', '