INV Cycle count schedule requests

Description
Categories: BI Publisher
Application: Inventory
Source: Cycle count schedule requests report (XML)
Short Name: INVARRTA_XML
DB package: INV_INVARRTA_XMLP_PKG
select  
      sr.inventory_item_id,
       sys.description  Description,
       sr.subinventory                       Subinventory,
       sr.revision                               Revision,
       sr.lot_number                         LotNumber,
       sr.locator_id                           Locator ,
       sr.schedule_date                    RequestDate,
       sr.count_due_date                  DueDate,
       mfg1.meaning                         RequestType,
       null    C_LOCATOR_FLEXDAT,
       &P_ITEM_FLEXSQL            C_ITEM_FLEXDAT,
      serial_number, 
	decode(sr.inventory_item_id,null,null,fnd_flex_xml_publisher_apis.process_kff_combination_1('f_item_flexval', 'INV', 'MSTK', 101, SYS.ORGANIZATION_ID, SYS.INVENTORY_ITEM_ID, 'ALL', 'Y',