APPS.INV_DIAG_MO_CAN_SO SQL Statements

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

Line: 37

   JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

Line: 58

    sqltxt := ' select ' ||
              ' mp.organization_code|| '' (''||mtr.organization_id ||'')'' "Organization|Code (Id)"' ||
              ' ,mif.item_number|| '' (''||mtr.inventory_item_id||'')'' "Item (Id)" ,' ||
              ' mtr.request_number "MO Number",' ||
              ' move_order_type "MO Type",' ||
              ' mtr.quantity_detailed "Qty Detailed",' ||
              ' mmtt_sum "Sum MMTT qty"               ' ||
              ' from  (SELECT move_order_line_id, sum(abs(transaction_quantity)) mmtt_sum' ||
                      ' FROM   mtl_material_transactions_temp ' ||
                      ' group BY move_order_line_id) mmtt , ' ||
                      ' ( select mtrl.organization_id, mtrl.inventory_item_id ,request_number,move_order_type, mtrh.header_id, line_id ,quantity_detailed from' ||
                      ' mtl_txn_Request_headers mtrh, mtl_Txn_Request_lines mtrl' ||
                      ' WHERE mtrh.header_id = mtrl.header_id'  ||
		      ' AND   mtrl.organization_id = ' || l_org_id  ;