APPS.INV_DIAG_OH_NOLOT_ITMLOT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 19

 sqltxt    VARCHAR2(9999);  -- SQL select statement

Line: 32

  JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

Line: 36

  sqltxt :='select  mp.organization_code|| '' (''||moqd.organization_id ||'')'' "Organization|Code (Id)"' ||
           ' ,mif.item_number|| '' (''||moqd.inventory_item_id||'')'' "Item (Id)" ' ||
           ' ,moqd.locator_id "Loc id",moqd.lot_number "Lot number",moqd.revision "Rev", moqd.subinventory_code "Subinv" ' ||
           ' from mtl_onhand_quantities_detail moqd,' ||
           ' mtl_parameters mp,mtl_item_flexfields mif' ||
           ' where moqd.organization_id = mp.organization_id(+)' ||
           ' and moqd.inventory_item_id = mif.inventory_item_id(+)' ||
           ' and moqd.organization_id = mif.organization_id(+)';

Line: 50

           ' and exists (select 1 from mtl_system_items_b msib' ||
           '            where msib.inventory_item_id= moqd.inventory_item_id' ||
           '             and   msib.organization_id = moqd.organization_id' ||
           '            and   msib.lot_control_code=2)'  ||
           ' group  by ' ||
           ' mp.organization_code || '' ('' || moqd.organization_id  || '')'',' ||
           ' mif.item_number|| '' (''||moqd.inventory_item_id||'')'',' ||
           ' moqd.inventory_item_id, moqd.subinventory_code, moqd.locator_id, moqd.lot_number, moqd.revision' ;