APPS.INV_DIAG_OH_SERIAL_STATUS 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.subinventory_code "Subinv",' ||
              ' moqd.locator_id "Loc id"       ,' ||
              ' moqd.lot_number "Lot Number"   ,' ||
              ' mtsv.status_code' ||
              ' ||'' (''' ||
              ' ||moqd.status_id' ||
              ' ||'')'' "StatusCode (Id)"' ||
              ' FROM     mtl_onhand_quantities_detail moqd,' ||
              ' mtl_parameters mp                ,' ||
              ' mtl_item_flexfields mif          ,' ||
              ' mtl_material_statuses_vl mtsv' ||
              ' WHERE    moqd.organization_id   = mp.organization_id' ||
              ' AND moqd.organization_id   = mif.organization_id' ||
              ' AND moqd.inventory_item_id = mif.inventory_item_id' ||
              ' AND mtsv.status_id         =moqd.status_id';