APPS.INV_DIAG_OH_PLAIN_NO_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"' ||
           ' FROM     mtl_onhand_quantities_detail moqd,' ||
           ' mtl_parameters mp                ,' ||
           ' mtl_item_flexfields mif' ||
           ' WHERE    moqd.organization_id   = mp.organization_id' ||
           ' AND moqd.organization_id   = mif.organization_id' ||
           ' AND moqd.inventory_item_id = mif.inventory_item_id';